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.