Cool Tips‎ > ‎

MSDB, SQLAgent and Maintenance Plans

 

Title

Description

Applicability

 

Convert MSDB Date and Time to DATETIME

Converts the MSDB job results date and time integer pair to a standard TSQL DATETIME datatype.


2000, 2005, 2008, 2008R2, 2012


Convert MSDB Date to Date String

Converts the MSDB job results date integer to a date string of the format 'DD MMM YYYY'. 


2000, 2005, 2008, 2008R2, 2012

 

Convert MSDB Time to Time String

Converts the MSDB job results time integer to a time string of the format 'HH:MM:SS' in 24-hour clock format.


2000, 2005, 2008, 2008R2, 2012


Convert MSDB Job Duration to Seconds

Converts MSDB integer format duration (HHMMSS) to #seconds. 


2000, 2005, 2008, 2008R2, 2012


Turn on Job Logging to Table

Sets the flag to have all SQL Agent (including MaintPlan) jobs to log to table (msdb..sysjobstepslogs) .


2000, 2005, 2008, 2008R2, 2012

 

List SQL Agent Jobs

Returns a list of one or many SQL Agent Jobs, along with schedule details.


2000, 2005, 2008, 2008R2, 2012

 

Decode MSDB Job Frequency   

Takes an MSDB frequency integer and decodes it into a formatted string with one or many days. 


2000, 2005, 2008, 2008R2, 2012

 

List SQLAgent Jobs Last Run Summary

Lists all SQL Agent Jobs plus a summary of their last run.



2000, 2005, 2008, 2008R2, 2012 

 

List SQLAgent Job Run Detail

Lists a single SQLAgent Job plus details of all runs (length of history determined by SQLAgent settings)


2000, 2005, 2008, 2008R2, 2012 

 

List Maintenance Plan Jobs Last Run Summary

Similar to SQLAgent Jobs Summary but only for SQL Server Maintenance Plan Jobs 


2000, 2005, 2008, 2008R2, 2012 

 

Maintenance Plan - Get Job Run Detail

Similar to SQLAgent Jobs Detail but only for SQL Server Maintenance Plan Jobs.  Includes detail lines for all tasks in each job 


2000, 2005, 2008, 2008R2, 2012 

 

List Currently Running Job Progress

 Produces a list of all currently running SQL Agent jobs, including estimated ETA.


2000, 2005, 2008, 2008R2, 
2012

 

 



 

 



Comments