Page History
SQL Enterprise Job Manager displays a calendar Calendar view of all your executed instances, jobs and , tasks (scheduled or manually), the ones that are currently running, and the ones that are scheduled to run in the future. , and job chains in containers. Each container provides a numeric value that represents the number of instances/jobs/tasks/job chains that exists within the time slot (row) in the Calendar.
By default, the Schedule tab displays your current date instances, jobs and tasks in , tasks, and job chains in a Day calendar view; however, you can change this setting to view your jobs and tasks them by:
- Week
- Month
- Snapshot
These settings are 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. Review this
How do you change the calendar behavior?
...
- 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, Snapshot), you can specify the date, time, and /or scale of your preference by selecting it from the Scheduled tab .
You can set the combinations of the Start / End date filter and Start / End time filter for the Calendar view using the Date & Time picker available on this option.
You can set the scale for the Calendar view. There is a drop-down box available with the following options:
- Hour (default)
- 30 minute
- 15 minute
- 5 minute
This settings are located on the top of the Schedule tab next to the Viewoption option. You You can navigate to previous or future weeks, months, or even years.The information displayed on the Calendar is filtered by
How do you change your time zone?
...
SQL Enterprise Job Manager displays all all instances, jobs and tasks of , tasks, and job chains of your selected day and identifies their status them with the following colors:
- red brown - failed jobinstancesyellow
- blue - canceled jobjobs
- green - succeeded jobtasks
- blue - running
- light blue - scheduled job
- gray - retry
- yellow - job chains
The Day view displays instances, jobs and tasks on , tasks, and job chains on their respective time slots and according to their duration. Each represented job or task displays the job or task name and the instance where it ran, is running, or will be run.
Tip |
---|
Hover over a jobs, tasks, job chains or task to view its time slot to get into the Snapshot view. This view displays specific details such as: NameOutcome, InstanceStatus, StatusType, Start time, End time, Duration, Maximum runtime, Average runtimeTime (GMT), Start Time (Local), Start Time (Server), Maximum Runtime, Average Runtime. |
When there are several jobs and tasks on the same time slot, SQL Enterprise Job Manager displays an ellipsis button at the right end of the time slot. Click this button to open a Job/Task schedules window which lists all available jobs and tasks that belong to that time slot. In this list, you can find the job/task name, instance, status, start time/date, and run duration information. Additionally, you can find the Export option in this new window, select your preferred format (CSV, PDF, or XML) to export all jobs and tasks available in the selected time slot.
Viewing your information by week
...