Versions Compared

Old Version 9

changes.mady.by.user Alejandra Rivera

Saved on

compared with

New Version Current

changes.mady.by.user Alejandra Barrientos

Saved on

Key

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

The Job Overlap Viewer allows allows you to  see to see which jobs are overlapped: running or scheduled to run at the same time across your registered SQL Server instances. 

...

For those overlapped jobs you can view the following information:

  • Instance Name -  -  overlapped Overlapped jobs across different instances in your environment.
  • Start Time  -  the  The start time of the overlapped jobs.
  • End Time  - when When each job finished executing. 
  • Duration  - the The duration time for each job. 
  • Overlapping Job  - the The name of the job.
  • Start Time -  -  the The start time of the overlapped jobs.
  • End Time  - when When the overlapped jobs finished jobs finished executing. 
  • Duration - the The duration time of the overlapped jobs. 
  • Total Overlap Time  -  the The total amount of time the jobs are overlapped.

...

On the top section of the Job Overlap viewer viewer, you  can select the Overlap Period. Specify a day and use the slider for a specific time range.

...

  • Instance name - select the instances for which you want to view overlapped jobs.
  • Job name - select the job for which you want to view conflicted conflicting events.
  • Duration  - use the time slider to define a job duration for which you want to view overlapped events.
Tip

When using filters take into accountconsider that:

  • Some filters have the option to Add Filter in case the information you are looking for is not listed. Once you click on Add Filter, a dialog box appears. Type the name you are looking for on the Search bar, then select it from the list, and Save. Your filter will be included under the filter list where you Addedadded it.
  • Click the respective checkbox to add or remove your selections.
  • If you want to select filters first and apply the changes later, deselect the Apply Filter Instantly option.

...

You can save your preferred filtering options by typing a name in the Add Filter wizard of the Custom Filter section, section and click clicking Save. Once you save your filter, you can retrieve it from the drop-down bottom of the Custom Filter option option available in on the left side under the Filter Table By section. 

...