Find the modified date of SQL Server Agents Jobs

On 06 May, 2015

T-SQL

By : Dave Jenkins

No Comments

Earlier on today I really needed to see the last modified date of a job that had been disabled. I didn’t know whether it was recent change or whether it was in the distant past. SQL Server Agent Job screen doesn’t have a ‘last modified’ column, so where did I turn to?

The SYSJOBS in the MSDB. Running the following code against it will bring back all the information we need. The start date is to narrow down data returned, you could remove it if you wish:

USE msdb;
GO 

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

SELECT
       name,
       [enabled],
       date_created,
       date_modified
FROM
       sysjobs
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

sysjobs

WHERE

date_modified >= @SearchDate AND

enabled = 0

ORDER BY

date_modified DESC;

Tags : Jobs SQL Server Agent T-SQL

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