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
|
|
|
|
|
|
|