Maintenance Plan is not working as expected.

  • Hi All,

    We have the Maintenance Plan which will backup all the database's daily. But unfortunately from the Last couple of day's it is not working. Below error's are shown in the history. Could you tell me what the issue is?

    1. The job failed. The Job was invoked by Schedule 3 (backup). The last step to run was step 1 (Subplan).

    2. Executed as user: SERVERNAME\SYSTEM. The package could not be loaded. The step failed.

    ---

  • Hi,

    Can you please check the event viewer and error log and post on this.

    Thanks

    Chandra Mohan N

    [font="Verdana"]Thanks
    Chandra Mohan[/font]

  • Hi,

    I got my it is happened. here i changed my sa password for my server.

    When i right click and say create to ==> it shows me the old sa password.

    Here i have one question.

    How can i send mail, if my SQL Server 2005 job getting failed?

    Appreciated your help!!!

    ---

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

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