downloads > white papers >

Practically all SQL Servers utilize automated processes. Backups, replication, log shipping, ETL processes all require automation to execute regularly and reliably. SQL Server Agent provides an easy and effective way to execute these processes as SQL Agent Jobs so they run according to the schedule you define. Often, this is sufficient to ensure proper maintenance and other events occur on a regular basis.

But, what if certain jobs rely on the successful completion of other jobs before they should run? What if a certain file needs to be available? You can make your best guess as to when that dependency might be met and schedule the job accordingly, but you may guess wrong. The previous job may run longer than you expected some days, allowing your next job to start before the previous one completes. Even when the dependencies are met, you may build in enough “buffer time” in the schedule to avoid an overlap, but likely lose time on the server while nothing is running.

SQL Server provides various scripts and platforms such as DTS or SSIS to allow the savvy DBA to develop packages of code to check for various dependencies and direct workflow accordingly. A certain amount of experience is typically required and the process can be time consuming to develop and maintain.

SQL Sentry Event Manager provides simple and easy methods for handling job monitoring and automation via visual job scheduling, robust alerting and response, and advanced job chaining.

 Download the white paper

 Video: Job Automation