Query to get job results

[foxdev]

I've snooped around and can't find anything to answer this, but I'm sure its possible since SQLS keeps this sort of thing in various system tables.

I need a query that will retrieve the last run result from DTS jobs and SQL Agent jobs. I could muck around in the tables for a few hours and figure it out, but I thought someone here may have this readily available. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[foxdev]

OK, it didn't take me "a few hours":

[tt]msdb.dbo.sp_help_jobhistory [/tt]
Robert Bradley

http://www.foxdev.com/

Coming Soon:

http://www.lowcostprints.com

http://www.agrainofhope.org