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-04-29 : 23:47:29
|
| Hi,I Scheduled a job to take a backup@everyday 11:00P.M.This job fails and showing the following error.SQL Server Scheduled Job 'DB Backup Job for DB Maintenance Plan 'LA'' (0x77C06CE237C0B4418CF661ADF98FEC43) - Status: Failed - Invoked on: 2008-04-30 08:12:47 - Message: The job failed. The Job was invoked by User DMN1\fisc-sql-svc. The last step to run was step 1 (Step 1). What could be the reason?? |
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-30 : 00:00:54
|
| Does User have permission to run job? |
 |
|
|
vinoth86
Starting Member
27 Posts |
Posted - 2008-04-30 : 00:08:36
|
| How to check,whethet that owner has a permission or not?? |
|
|
|
sodeep
Master Smack Fu Yak Hacker
7174 Posts |
Posted - 2008-04-30 : 00:10:10
|
| Double click DMN1\fisc-sql-svc in Security-logins and see what permission it has? |
|
|
|
vinoth86
Starting Member
27 Posts |
Posted - 2008-04-30 : 00:30:19
|
| Yes,It has accesss to that databases. |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2008-04-30 : 23:12:03
|
| Check sql server log and plan's log file, they'll tell you why it failed. |
|
|
|
|
|
|
My Backup-job failed.