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

MAINTENANCE JOB FAILURE Expand / Collapse
Author
Message
Posted Friday, May 24, 2013 3:13 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Tuesday, July 23, 2013 12:03 PM
Points: 112, Visits: 240
Hello,

Could someone tell me why a job could be reported as 'succeeded' under maintenance plan history but 'failed' under SQL Agent job history for the same job?

Thanks.
Post #1456336
Posted Friday, May 24, 2013 4:20 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Thursday, July 3, 2014 4:01 AM
Points: 709, Visits: 1,409
What is logged in the history of the maintenance plan and the SQL Agent job?

Joie Andrew
"Since 1982"
Post #1456366
Posted Friday, May 24, 2013 4:25 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, July 11, 2014 9:55 AM
Points: 5,208, Visits: 9,365
sahoong (5/24/2013)
Hello,

Could someone tell me why a job could be reported as 'succeeded' under maintenance plan history but 'failed' under SQL Agent job history for the same job?

Thanks.

One possible reason is that the On success action of the final job step is Quit the job reporting failure.

John
Post #1456371
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse