Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Christina Agyeman
Starting Member
15 Posts |
 Posted - 2002-05-28 : 06:17:34
|
| I am using SQL Server 7. I have created a maintenance plan that backup our databases using Local System Account for SQL Agent. The files are backed up to a local drive.The jobs created by the maintenance plan do not succeed. Other jobs on the server executes successfully. I have enabled all the jobs. Any suggestions? |
|
|
Wanderer
Master Smack Fu Yak Hacker
1168 Posts |
Posted - 2002-05-28 : 06:47:52
|
| What does the job history say ? Check in Ent Man under:Management > SQL server Agent > Jobs . Right click failed job, and choose "View Job History" Tick on "Show detail steps" - top right on new window. |
 |
|
|
Christina Agyeman
Starting Member
15 Posts |
Posted - 2002-05-28 : 06:56:22
|
| The message on the jobs history stateThe job failed. The Job was invoked by User sa. The last step to run was step 1 (Step 1). |
|
|
|
MuadDBA
628 Posts |
Posted - 2002-06-03 : 16:10:20
|
| Check the database maintenance plan history instead...it should provide you with more details. Under Management, right-click on database maintenance plans, and select maintenance plan history. Select failed under the status, and see if you get more information. |
|
|
|
|
|
|
Maintenance Plan