Wednesday, May 22, 2013

SQL Server Job Information

SELECT
    name   
,    enabled   
,    description   
,    suser_sname(owner_sid)
,    CAST (date_created AS DATE)
,    CAST (date_modified AS DATE)    
,    version_number
FROM msdb.dbo.sysjobs;

No comments: