SQL Clone
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in

Articles with tag Job history Rss

Search for any content tagged job history

   Items 1 to 2 of 2   

Monitoring job history using Reporting Services

Easily monitoring your SQL Agent job history using SSRS for concurrency, job lenght and job status.  Read more...
By Tomaž Kaštrun 2013/09/05 | Source: SQLServerCentral.com | Category: agent jobs
Rating: |  Discuss |   Briefcase | 7,727 reads

Querying SQL Server Agent Job History Data

Often times we are tasked with having to programmatically come with a list of durations per SQL Server Agent Job to trend the run times and order the results by date. Unfortunately it's not always easy in the way the data is stored in the system tables in the MSDB database. This tip explains how to use the system tables to get the data into the correct format for dates and job durations.  Read more...
By Additional Articles 2013/01/02 | Source: MSSQLCity.com | Category: sql server agent
Rating: (not yet rated)  Rate this |   Briefcase | 3,781 reads
   Items 1 to 2 of 2