Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Agent Jobs Query Expand / Collapse
Author
Message
Posted Saturday, February 16, 2013 9:22 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, January 17, 2014 3:49 AM
Points: 80, Visits: 262
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
Posted Sunday, February 17, 2013 7:31 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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
Posted Monday, February 18, 2013 3:35 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, January 17, 2014 3:49 AM
Points: 80, Visits: 262
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
Posted Monday, February 18, 2013 6:39 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Wednesday, April 16, 2014 9:25 AM
Points: 7,070, Visits: 12,523
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
Posted Tuesday, February 19, 2013 4:32 AM
SSC Journeyman

SSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC JourneymanSSC Journeyman

Group: General Forum Members
Last Login: Friday, January 17, 2014 3:49 AM
Points: 80, Visits: 262
Thanks for your help. I'll take a look at BOL.
Post #1421546
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse