Post reply

Agent Jobs Query

  • February 16, 2013 at 9:22 am

    #289662

    Hi,

    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.

    Thanks

  • February 17, 2013 at 7:31 am

    #1588665

    Have you tried your SQL 2000 query on 2008? The system tables that support haven't changed much with respect to determining job success or failure, if at all.

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 18, 2013 at 3:35 am

    #1588772

    Thanks for the reply. I havent tried it yet, as Id like to update it and maybe add some more functionality. Are there any articles you're aware of where I could find some more info on this type of job please?

  • February 18, 2013 at 6:39 am

    #1588820

    SQL Server Books Online (BOL) is almost always my first stop when wanting to learn more about a feature of SQL Server. Here is a link to an article in BOL that goes into detail about Agent Jobs.

    Implementing Jobs

    There are no special teachers of virtue, because virtue is taught by the whole community.
    --Plato

  • February 19, 2013 at 4:32 am

    #1589121

    Thanks for your help. I'll take a look at BOL.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply