Page History
SQL Enterprise Job Manager displays a calendar Calendar view of all your executed instances, jobs, tasks, and tasks (scheduled or manually), the ones that are currently running, and the ones that are scheduled to run in the future. 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 and tasks in a , 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 The Week and Month view are available in the left section of the tab in the drop-down menu options from View. 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 by selecting it from the calendar option next to Date. You can navigate to previous or future weeks, months, or even years.
...
.
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 a Scale for the Calendar view. The Scale defines the interval time axis of the Calendar and 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 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
SQL Enterprise Job Manager displays all jobs and tasks of your selected day and identifies their status with the following colors:
- red - failed job
- yellow - canceled job
- green - succeeded job
- blue - running
- light blue - scheduled job
- gray - retry
The Day view displays jobs and tasks 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 job or task to view its specific details such as: Name, Instance, Status, Start time, End time, Duration, 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
If you select to view your information by Week, SQL Enterprise Job Manager changes to a weekly view with the days of the week of your current date. You can modify this week by going to the calendar option on the left side or your Scheduled tab and selecting a date of the week you require.
The weekly view displays all jobs and tasks per day for each day of the selected week. You can identify the status of jobs and tasks with the following colors:
- red - failed job
- yellow - canceled job
- green - succeeded job
- blue - running
- light blue - scheduled job
- gray - retry
To view all jobs and tasks in a specific time slot, click the ellipsis button at the right end of the time slot and SQL Enterprise Job Manager opens a Job/Tasks schedules window with all jobs and tasks that belong to the same time slot. In this list, you can find the job or 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.
If you want to see with more detail the jobs and tasks for a day, click the date at the top of the calendar view, and SQL Enterprise Job Manager opens the Day view of the selected day.
Tip |
---|
Hover over a job or task to view its specific details such as: Name, Instance, Status, Start time, End time, Duration, Maximum runtime, Average runtime. |
Viewing your information by month
If you select to view your jobs information by Month, SQL Enterprise Job Manager displays a monthly view corresponding to your current date.
The Month view displays a job and summary status in each day of the month. The summary status includes if there are Running jobs, Failed runs, Successful runs, Canceled runs, or Scheduled runs.
If you want to see with more detail the jobs and tasks for a day, click the number of the respective calendar day, and SQL Enterprise Job Manager opens the Day view of the selected day.
SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
Anchor | ||||
---|---|---|---|---|
|
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 more options icon to select the information you want to hide or show on the Operation list view. |
...