Complete a Server Assessment – Auto Delete Jobs

Return to Code Library Main Page

Below you will find the code for the Index Fragmentation for an object.  Simply select the text and copy to the Clipboard.

SELECT name
, description
, date_created
, date_modified
, USER_NAME(owner_sid) AS ‘JobOwner’
FROM msdb.dbo.sysjobs
WHERE delete_level > 0

This code was written using the Microsoft SQL Server documentation.  If you find that this code was copied from else where, please let me know so I can give proper credit.