Versions Compared

Old Version 8

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version 9

changes.mady.by.user Alejandra Rivera

Saved on

Key

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

...

SQL Enterprise Job Manager displays all instances, jobs, tasks, and job chains per day and time for each 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. 

If you set the Start / End Date filter to view your information by Month, SQL Enterprise Job Manager displays a monthly view corresponding to your current date.

The Month view displays all instances, jobs, tasks, and job chains per day and time for each day of the selected month. If you want to see more details, click the instances, jobs, tasks, or job chains of the calendar view, and SQL Enterprise Job Manager opens the Snaspshot view of the selected day and time.

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  gear icon to select the information you want to hide or show on the Operation list of your Scheduled view.

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. The instance containers reflect all jobs, tasks, and job chains that are running under the instance or on the server hosting that instance.

Note

Keep in mind:

  • The tittle of the containers are the name of the instances, jobs, tasks, and/or job chains.
  • 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.
  • The placement of the container on the calendar will be 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.
  • 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.

  • You can drag and drop a job, task, or job chain container to reschedule it.

  • The edges of the calendar allows you to navigate to the previous or next hour.


Viewing your information on the Operation List

...