Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

  • The tittle of the containers are the name of the instances, jobs, tasks, and/or job chains.
  • You can identify your instances, jobs, tasks, and job chains with the following colors:

    • Brown - instances
    • Blue - jobs
    • Green - tasks
    • Yellow - job chains
  • Each container provides a numeric value that represents the number of instances, jobs, tasks, and job chains that exists within the time slot (row) in the Calendar view.

How is the information displayed on the

...

Calendar view?

By default, the Schedule  tab displays your current date instances, jobs, tasks, and job chains in a Day calendar view; however, you can change this setting to view them by:

...

To find more information, go to Viewing your jobs on the Schedule tab.

How do you change the

...

Calendar behavior?

The Schedule tab has a View drop-down box that allows you to filter the calendar information according to your requirements. The following options are available:

...

By default, SQL Enterprise Job Manager displays your calendar according to your system time zone. However, you can change this value and set a different time zone by going to Timezone, on the top section of your calendar view, and selecting your required option from the drop-down UTC list. 

...

How is the information displayed on the Operation

...

list?

The operation list displays a list of all jobs, tasks, and job chains that match the filters selected on the Schedule view. This list also filters items based on the options specified on the Calendar view. The following options are available:

  • Outcome - the current status of the job, task, or job chain scheduled. It can be: Successful or Failed.
  • Status - displays the current status of the job, task, or job chain.
  • Type - displays the type of work running, such as job, task, or job chain.
  • Start Time (GMT) - displays the start time of the job, task, or job chain running.
  • Start Time (Local) - displays the local time zone of the browser.
  • Start Time (Server) - displays the time zone of the instance/server managed.
  • Max Runtime - the maximum run time of a job, task, or job chain.
  • Avg. Runtime - the average run time of a job, task, or job chain.
Tip

Click the Image Added gear icon to select the information you want to hide or show on the Operation list view.

SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >

...