Versions Compared

Old Version 10

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version 11

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 a Calendar view of all your executed instances, jobs, tasks, 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

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
    • Brown - instances
    blue
    • Blue - jobs
    green
    • Green - tasks
    yellow
    • 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 Schedule tab?

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:

  • Week
  • Month
  • Snapshot

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.

...

Each container displays information about specific instance, job, task, and job chain.

Keep in mind:

The tittle of
Note
The instance containers reflect all jobs, tasks, and job chains that are running under the instance or on the server hosting that instance.
Note

  • 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
  • The edges of the Calendar allows you to navigate to the previous or next hourIf 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

...