SQL Agent Insights:Documentation:Job Monitor Suspend Job: Difference between revisions
| Line 15: | Line 15: | ||
* wanted to put a job into maintenance without creating complex schedules or assigning multiple schedules to a job? | * 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? | * 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? | * 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. | If the answer is yes to any of those questions, you may benefit from the suspension / pausing of SQL agent jobs. | ||
Revision as of 01:10, 16 February 2023
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. |
 |
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.
Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8