SQL Agent Insights:Documentation:Job Monitor Context Menu: Difference between revisions
Line 57: | Line 57: | ||
=== Start Job at Step... === | === Start Job at Step... === | ||
Opens a new dialog allowing one to select the job step in which to start the selected job. | |||
=== Stop Job === | === Stop Job === |
Revision as of 02:56, 14 February 2023
The Job Monitor has the following options available when right-clicking on any job within the job pane.
View Job History for [selected job]
Opens the Job History window for the selected job.
Purge Job History
The purge job history context menu option has three options as follows:
- Purge job history for [selected job]
- Opens the Purge Job History dialog with the focus on the selected job.
- Purge job history for all filtered jobs
- Opens the Purge Job History dialog with the focus on all filtered jobs, i.e. any jobs that are currently visible in the Job Monitor.
- Purge job history for all jobs
- Open the Purge Job History dialog with the focus of all jobs on the monitored instance regardless if they have been filtered.
Job Scripting Actions...
The job scripting actions context menu expands exposing the following choices one has for scripting within SQL Agent Insight's Job Monitor.
- Script job [selected job] as CREATE
- Opens the script output window and will script the selected job so that it can be recreated.
- Script job [selected job] as DELETE
- Opens the script output window and will script the selected job so that it can be deleted. This does not delete the underlying job.
- Script ALL jobs on [monitored instance] as CREATE
- Opens the script output window and will script all jobs so they can be recreated.
- Script ALL jobs on [monitored instance] as DELETE
- Opens the script output window and will script all jobs so they can be deleted. This does not delete any jobs.
- Script all filtered jobs as CREATE
- Opens the script output window and will script all filtered job in Job Monitor so they can be recreated.
- Script all filtered jobs as DELETE
- Opens the script output window and will script all filtered jobs in Job Monitor so they can be deleted. This does not delete any jobs.
- Script all jobs in category [selected jobs category] as CREATE
- Opens the script output window and scripts all jobs in Job Monitor that have the same category as the selected job so they can be recreated.
- Script all jobs in category [selected jobs category] as DELETE
- Opens the script output window and scripts all jobs in Job Monitor that have the same category as the selected job so they can be deleted. This does not delete any jobs.
- Script all jobs with schedule [selected jobs schedule] as CREATE
- This action will be disabled if the selected job does not have a schedule.
- This actions text will change to reflect if the selected job has multiple schedules.
- Opens the script output window and scripts all jobs in Job Monitor that have the same schedule(s) as the selected job so they can be recreated.
- Script all jobs with schedule [selected jobs schedule] as DELETE
- This action will be disabled if the selected job does not have a schedule.
- This actions text will change to reflect if the selected job has multiple schedules.
- Opens the script output window and scripts all jobs in Job Monitor that have the same schedule(s) as the selected job so they can be deleted. This does not delete any jobs.
Start Job at Step...
Opens a new dialog allowing one to select the job step in which to start the selected job.
Stop Job
Suspend Job
Resume Job
Enable Job
Disable Job
Rename Job...
Delete Job...
Properties...
Microsoft®, Windows® and SQL Server® are registered trademarks of Microsoft Corporation in the United States and/or other countries.
Some icons courtesy of Icons8