Batch Job Creation
I have just purchased SQL Backup 4.6 and I must create 3 jobs each for 200 databases (weekly FULL, nightly DIFF and daytime incrmntal LOGs every 2 hours).
Each database goes to a different existing directory, not named for the database. Each database requires encryption using a different password, and each database requires notification to a different email address.
I also intend to stagger the schedules over 2 minute intervals based for weekly full, nightly differential, and daytime T-Log backups every two hours in order to minimize impact on performance of the server.
I wish to maintain a single name for each backup output file so that it is replaced by the next execution of the job, but I also want to copy the backup to a sub-directory upon completion for safekeeping until the next job finishes successfully.
What options, if any, are available to automate the process of creating these jobs given these requirements, even if the automation is partial?