Last Modified date of SQL Server Agent Job schedules

On 07 May, 2015

T-SQL

By : Dave Jenkins

No Comments

As a follow on to yesterdays code snippet about finding the last modified date of SQL Server Agent Jobs, I thought I would apply the same code to find the last modified date of SQL Server Agent Job schedules. Always handy knowing when someone has disabled a schedule.

USE msdb;
GO 

DECLARE @SearchDate DATETIME;
SET @SearchDate = '01 JAN 2015' 

SELECT
       name,
       [enabled],
       date_created,
       date_modified
FROM
       sysschedules
WHERE
       date_modified >= @SearchDate AND
       enabled = 0
ORDER BY
       date_modified DESC;
GO

USE msdb;

DECLARE @SearchDate DATETIME;

SET @SearchDate = '01 JAN 2015'

SELECT

name,

[enabled],

date_created,

date_modified

FROM

sysschedules

WHERE

date_modified >= @SearchDate AND

enabled = 0

ORDER BY

date_modified DESC;

Previous Post Next Post

About The Author

Dave Jenkins

Hello! I'm Dave Jenkins and I have been working with MS SQL Server for two years. I'm an MCP (70-461) working towards an MCSA. I love working with MS SQL Server and the BI Stack.

Number of Posts : 26

All Posts by : Dave Jenkins