I would like to check each morning if my agent jobs have completed successfully. What would be the best method to do this? I'm assuming an agent job which queries the system tables. If anyone could point me in the direction of a query that would do this, then I'd appreciate it. I have a query for SQL 2000, but Im using SQL 2008 so I'm assuming there are more system table options available now.