Joe's Knowledge Base - a collection of various tips-n-tricks for SQL Server.
Note: best effort to site sources where applicable, otherwise curated from BOL/MSDN or self-created.
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:
Post a Comment