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 |
|
LopakaB
Starting Member
22 Posts |
 Posted - 2011-12-01 : 13:01:42
|
| I created a job to execute every night at 1:00 AM. It fails every time... I can run the stored procedure in query analyzer with out fault... Any ideas?thank youLopaka |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-01 : 13:02:59
|
| can you give more information on error due to which it fails. Look into job history to see that------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2011-12-01 : 13:15:55
|
| Make sure SQL Agent service account has permissions to execute that procedure. |
|
|
|
LopakaB
Starting Member
22 Posts |
Posted - 2011-12-01 : 13:18:37
|
| "The job failed. The Job was invoked by Schedule 596(start1). The last step to run was step 1."Runs a stored procedure...Lopaka |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2011-12-02 : 01:04:15
|
| sorry this error message doesnt have enough information. do you have any other error messages or any more information from Error log?------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Scheduled Job Fails