there is a scripts section here on SSC with literally thousands of script contributions.
you can use the search feature in the upper right corner of this page...
i used it to search for "script job details" and here's the first link:
http://www.sqlservercentral.com/scripts/Maintenance+and+Management/31739/[/url]
Lowell
--
help us help you! If you post a question, make sure you include a CREATE TABLE... statement and INSERT INTO... statement into that table to give the volunteers here representative data. with your description of the problem, we can provide a tested, verifiable solution to your question! asking the question the right way gets you a tested answer the fastest way possible!