Page History
SQL Enterprise Job Manager displays a Calendar view of all your executed instances, jobs, tasks, and job chains in containers.
How do you identify the containers?
- 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 a Day calendar view; however, you can change this setting to view them by:
...
The Week and Month view are available when you set the combinations of the Start / End Date filter and Start / End Time filter. The Snapshot view is available when you click on either the containers or the time slot.
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:
- All - displays all jobs, tasks, and job chains in the Calendar and Operation list.
- Jobs Only - displays all jobs in the Calendar and Operation list.
- Tasks Only - displays all tasks in the Calendar and Operation list.
- Job Chains Only - displays all job chains in the Calendar and Operation list.
- Empty Time Slot - displays the time slots where there are no jobs, tasks, and/or job chains scheduled. This option is highlighted with yellow color in the Calendar.
- Overlap Period - displays the time slots where an overlapping of jobs, tasks, and/or job chains exist. This option is highlighted with orange color in the Calendar.
How do you change the date, time, and scale filters?
For any of these views (Day, Week, Month), you can specify the date, time, and scale of your preference.
...
This settings are located on the top of the Schedule tab next to the View option. You can navigate to previous or future weeks, months, or even years.
How do you change your time zone?
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.
Viewing your information by Day
| Anchor | ||||
|---|---|---|---|---|
|
The operation list displays a list of all SQL Enterprise Job Manager displays all instances, jobs, tasks, and job chains of your selected day on their respective time slots in the calendar.
Set the Start / End Date filter to view your information by Day. SQL Enterprise Job Manager changes to a day view with the day you selected. You can modify this date view by going to the top section of the Scheduled tab and select the dates you require.
| Tip |
|---|
Hover over jobs, tasks, job chains or time slot (specific date) to get into the Snapshot view. This view displays the Instance and the Average Runtime of your selection at that particular time. For example: click on Jobs, the Snapshot view will display only Jobs for that particular time slot on which the clicked Job exists. Additionally, you can view specific details of your selection on the Operation list, such as: Outcome, Status, Type, Start Time (GMT), Start Time (Local), Start Time (Server), Maximum Runtime, Average Runtime. Click the |
Viewing your information by Week
SQL Enterprise Job Manager displays all instances, jobs, tasks, and job chains per day and time for each day of the selected week on their respective time slots in the calendar.
Set the Start / End Date filter to view your information by Week. SQL Enterprise Job Manager changes to a weekly view with the days of the week you selected. You can modify this week view by going to the top section of the Scheduled tab and select the dates of the week you require.
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 |
| Tip |
Hover over jobs, tasks, job chains or time slot (specific day an hour) to get into the Snapshot view. This view displays the Instance and the Average Runtime of your selection at that particular time. For example: click on Jobs, the Snapshot view will display only Jobs for that particular time slot on which the clicked Job exists. Additionally, you can view specific details of your selection on the Operation list, such as: Outcome, Status, Type, Start Time (GMT), Start Time (Local), Start Time (Server), Maximum Runtime, Average Runtime. Click the |
Viewing your information by Month
SQL Enterprise Job Manager displays all instances, jobs, tasks, and job chains per day of the selected month on their respective time slots in the calendar.
Set the Start / End Date filter to view your information by Month. SQL Enterprise Job Manager changes to a monthly view with the days of the month you selected. You can modify this month view by going to the top section of the Scheduled tab and select the dates of the month you require.
| Tip |
|---|
Hover over jobs, tasks, job chains or time. slot to get into the Snapshot view. This view displays the Instance and the Average Runtime of your selection at that particular time. For example: click on Jobs, the Snapshot view will display only Jobs for that particular time slot on which the clicked Job exists. Additionally, you can view specific details of your selection on the Operation list, such as: Outcome, Status, Type, Start Time (GMT), Start Time (Local), Start Time (Server), Maximum Runtime, Average Runtime. Click the |
Viewing your information through the Snapshot view
The Snapshot view allows you to get detailed information of jobs, tasks, and/or job chains that exists within a specific time slot.
It can be accessed when the Start / End Date are the same and the Start / End Time are a maximum of an hour apart.
Each container displays information about specific instance, job, task, and job chain.
| Note |
|---|
| The instance containers reflect all jobs, tasks, and job chains that are running under the instance or on the server hosting that instance. |
How are the containers displayed on the Snapshot view?
- Each container displays the average run time in seconds of the specific job, task, or job chain.
- If the job, task, or job chain has already ran and completed, then the actual run time (duration) is displayed instead of the average run time.
- If a specific job, task, or job chain run successively with less than 5 minutes in between each run, then the containers are merged into one container.
How are the containers placed on the Calendar view?
- The placement of the container on the Calendar view are determined by the start time of the job, task, or job chain for which the container represents.
- The placement of the right edge of the container depends on the average run time or actual run time.
- Containers that extend the past visible of the Calendar area, displays an ellipsis to indicate that there is information hide.
| Tip |
|---|
|
Viewing your information 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.
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
...
...