SQL Agent Insights:Documentation:Job Monitor Suspend Job: Difference between revisions
No edit summary |
|||
| Line 18: | Line 18: | ||
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. | ||
== Prerequisites == | |||
== Viewing all Suspended Jobs == | |||
<hr> | <hr> | ||
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.
Prerequisites
Viewing all Suspended 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