Suspending a Job

The functionality of suspending a job is a unique feature within SQL Agent Insight that other products do not have. Suspending a job will pause the selected job from running until the selected future date and time chosen by the user at which point the job will automatically resume.

The *Suspend Job* context menu item and its immediate options.

Why suspend a job?

Have you ever…

disabled a job and forgotten to enable it again?
wanted to put a job into maintenance without creating complex schedules or assigning multiple schedules to a job?
wanted to restore a database and ensure jobs that run against that database are paused?
do troubleshooting and want to minimize potential system overhead by performance intensive jobs?

If the answer is yes to any of those questions, you may benefit from the suspension / pausing of SQL agent jobs.

Back to Documentation Main

Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8