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: Monday, May 12, 2014 10:34 AM
Points: 81, Visits: 265
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: Today @ 6:57 AM
Points: 7,084, Visits: 12,577
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
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: Monday, May 12, 2014 10:34 AM
Points: 81, Visits: 265
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: Today @ 6:57 AM
Points: 7,084, Visits: 12,577
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
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: Monday, May 12, 2014 10:34 AM
Points: 81, Visits: 265
Thanks for your help. I'll take a look at BOL.
Post #1421546
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse