Agent Jobs Query

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » SQL Server 2008 » SQL Server 2008 Administration » Agent Jobs Query

Agent Jobs Query

Rate Topic

Display Mode

Topic Options

Author

Message

ggjjbb1983

Posted Saturday, February 16, 2013 9:22 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:52 AM
Points: 76, Visits: 240

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

Post #1420896

opc.three

Posted Sunday, February 17, 2013 7:31 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737, Visits: 11,791

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1420978

ggjjbb1983

Posted Monday, February 18, 2013 3:35 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:52 AM
Points: 76, Visits: 240

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?

Post #1421125

opc.three

Posted Monday, February 18, 2013 6:39 AM

SSCertifiable

Group: General Forum Members
Last Login: Today @ 8:26 AM
Points: 6,737, Visits: 11,791

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

Believe you can and you're halfway there. --Theodore Roosevelt

Everything Should Be Made as Simple as Possible, But Not Simpler --Albert Einstein

The significant problems we face cannot be solved at the same level of thinking we were at when we created them. --Albert Einstein

1 apple is not exactly 1/8 of 8 apples. Because there are no absolutely identical apples. --Giordy

Post #1421184

ggjjbb1983

Posted Tuesday, February 19, 2013 4:32 AM

SSC Journeyman

Group: General Forum Members
Last Login: Thursday, May 09, 2013 8:52 AM
Points: 76, Visits: 240

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

Post #1421546

« Prev Topic | Next Topic »

Permissions