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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2005-05-17 : 07:44:22
|
| Dick writes "On a server running SQL Server 7 I have a stored procedure that creates a Data Warehouse. I have scheduled a job that runs nightly to run this stored procdure. The job ran successfully for a couple of weeks and then started failing. View Job History does not give me any meaningful information on why the job failed. If I try to start the job from the SQL Server Agent it will fail. Yet if I go into Query Analyzer and run the stored procedure from there it will run fine every time.Any ideas on why it is happening/fixes?Thanks,Dick" |
|
|
nr
SQLTeam MVY
12543 Posts |
Posted - 2005-05-17 : 07:52:21
|
| Could be the user that the agent is running under?Try recreating the job.What is the error it gives.==========================================Cursors are useful if you don't know sql.DTS can be used in a similar way.Beer is not cold and it isn't fizzy. |
 |
|
|
|
|
|
SQL Server Agent Jobs - bombs for no apparent reason