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 |
|
vinoth86
Starting Member
27 Posts |
 Posted - 2008-05-02 : 02:56:23
|
| Hi,I Scheduled to run a job at every day@11P.M.The job has been failing every day.This is the error message... SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'LA'' (0x77C06CE237C0B4418CF661ADF98FEC43) - Status: Failed - Invoked on: 2008-05-01 23:00:03 - Message: The job failed. The Job was invoked by Schedule 200 (Schedule 1). The last step to run was step 1 (Step 1). Anyone can hepme ASAP!! |
|
|
Lumbago
Norsk Yak Master
3271 Posts |
Posted - 2008-05-02 : 06:50:15
|
| Look at the step details for the job and see the error message in step 1. It will hopefully be a little more informative.--Lumbago |
 |
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
Posted - 2008-05-03 : 07:57:50
|
| The other thing you could do is set to save the Output to a Log file,Jack Vamvas--------------------Search IT jobs from multiple sources- http://www.ITjobfeed.com |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-05-03 : 14:39:52
|
| Looks like permission issue. Does user have necessary permission to run job? |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-05-03 : 20:39:29
|
| You can find out why backup failed in sql server log. |
|
|
|
|
|
|
My backup job failed.