Maintenance Plan is not working as expected.

• SqlUser-529296

  SSCarpal Tunnel

  Points: 4072

  More actions

  January 27, 2009 at 12:03 am

  #126952

  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.

  ---

• Chand00

  SSCertifiable

  Points: 6466

  More actions

  January 27, 2009 at 12:23 am

  #933026

  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]

• SqlUser-529296

  SSCarpal Tunnel

  Points: 4072

  More actions

  January 27, 2009 at 5:33 am

  #933109

  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!!!

  ---