Applies to: SQL Agent Insight version 0.23

Job Monitor Context Menu Options

The Job Monitor has the following options available when right-clicking on a given job.

VIEW JOB HISTORY FOR [selected job]

  • Opens the Job History form 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 purging dialog with the focus on the selected job.
  • Purge job history for all filtered jobs
    • Opens the purging 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 purging dialog with the focus of all jobs on the monitored instance regardless if they have been filtered.
Click to enlarge.

JOB SCRIPTING ACTIONS

  • 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 AT JOB STEP

  • Opens a new dialog allowing one to select the job step in which to start the selected job.

STOP JOB

  • Sends a stop job request to the SQL Agent on the monitored instance.

SUSPEND JOB

  • Suspending a job is a unique feature within SQL Agent Insight that other products do not have. In the background, technically, when a job is “suspended” it is actually disabled, storing the data in 2 controller jobs within the monitored instance. From the context menu of any job that is not currently suspended, the following quick options are available. Alternatively, to select an option not in the context menu, select “Custom” to pick the date and time in which to resume operation of the selected job.
  • 1 hour
  • 4 hours
  • 6 hours
  • 12 hours
  • 24 hours
  • 2 days
  • 7 days
  • 30 days
  • Custom
■ NOTE
Suspending a job will keep track of the jobs current state upon resuming. That is, if the job was disabled at the time of suspension, the job upon resumption will also be in a disabled state.
Conversely, a job that was in an enabled state will technically be disabled while suspended, however, when the job is resumed, it will be put back into an enabled state.

RESUME JOB

  • Resuming a job is a unique feature within SQL Agent Insight that does not exist in other products. The job must previously have been suspended for this option to be available.
  • Resuming a job will immediately remove the job from the suspend/resume queue and put the selected job to its original state at the time of suspension. See the note above.

ENABLE JOB

  • This option is available only if the job is currently disabled. Will immediately take a disabled job and enable it within the SQL Agent engine.

DISABLE JOB

  • This option is only available if the job is currently enabled. Will immediately take an enabled job and disable it within the SQL Agent engine.

RENAME JOB

  • Opens the rename job dialog giving the opportunity for the user to specify a new name for the selected job. The job history is preserved with the renaming.

DELETE JOB

  • Opens the delete job dialog giving the following 2 options prior to deleting the job:
    • Keep unused job schedules?
      • Signals to the SQL agent to keep any schedules that go unused even after this job is deleted.
    • Script job as Create before deletion?
      • Opens the script output window and will script the selected job so that it can be recreated if required post deletion.

PROPERTIES

  • Opens the job properties window. This is a read-only view into all settings for the selected job, with each section accessible by the row of tabs at the top of the job properties window.
Click to enlarge.