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 |
|
bjornenbo
Starting Member
2 Posts |
 Posted - 2007-08-07 : 04:19:12
|
| Hi,I have problem that I hope someone can help me with. I am trying to do a job in Enterprise Manager in SQL Server 2000. The message I'am reseiveing when the job is done looks like this:The job failed. The Job was invoked by User YOUR-BCC8BD2706\Administrator. The last step to run was step 1 (nollstall).I want a store procedure to be called every first day of the month. The store procedure resets the month account and looks like this:create proc ResetMonthAccountasdeclare @MonthAccount intset @MonthAccount = 0update Userset monthaccount = @MonthAccount/bjornenbo |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2007-08-07 : 12:18:43
|
| There is nothing wrong with what you have posted. You'll need to check the job details to find out what error it is throwing. Go to job history for the job, then select the option to show job details. You should now be able to click on the job step to see the actual error. Post it here if you can't figure out what it means.Tara Kizerhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
|
|
|
How to create a job in SQL Server 2000