You can find the Job Overlap Viewer on the top right corner options of any specific Job details view. To access the Job details view of a job, click the name of the job in the Jobs tab. 

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

What information can you see in the Job Overlap Viewer?

For those overlapped jobs you can view the following information:

  • Instance name -  overlapped jobs across different instances in your environment
  • Start time -  the start time of the overlapped jobs
  • End time - when each job finished executing 
  • Duration - the duration time for each job 
  • Overlapping job - the name of the job

Additionally, on the top right corner you can find the following information:
  • Total overlap events - a counter of the total number of overlapped jobs 
  • Total overlap - the total amount of time the events are overlapped.

How can you filter and organize your information in the Job Overlap Viewer?

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

Additionally, you can filter the information available on this view with the following options:

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

To export the information on this view, use the Export option and select your preferred format: CSV, PDF, or XML. 

SQL Enterprise Job Manager monitors and manages your SQL Server agent jobs. Learn more > >
  • No labels