Post reply

maintenance plan failed - job success

  • June 18, 2009 at 1:36 pm

    #135226

    I have a SQL 2005 SP3 Ent 64bit on Win 2003 R2 Ent 64bit SP2, we have setup a maintenance plan that is backing up the transaction log of all our user databases, about 200. The maintenance plan failed because two of the dbs were in Simple mode, but the job allways reported success.

    Have anybody experienced this?

  • June 18, 2009 at 1:39 pm

    #1012021

    what i can think of is there is a setting in the job. If job step fails, go to next step. just check that out to be sure...


    Pradeep Singh

  • June 18, 2009 at 1:51 pm

    #1012027

    You are right, thanks.

    It looks like by default the maintenance plans steps are join by "on completion", not by "on success".

    I found a doc

    http://support.microsoft.com/kb/288577

    that imply that the normal behaviour should be when Maintenance Plan failes the job is failing, which I didn't cross my mind that might not be that way.

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

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