Post reply

MAINTENANCE JOB FAILURE

  • May 24, 2013 at 3:13 am

    #394842

    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.

  • May 24, 2013 at 4:20 am

    #1618156

    What is logged in the history of the maintenance plan and the SQL Agent job?

    Joie Andrew
    "Since 1982"

  • May 24, 2013 at 4:25 am

    #1618160

    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

Viewing 3 posts - 1 through 2 (of 2 total)

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