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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Administration (2000)
 Sql agent job reports failure

Author  Topic 

rongrzywacz
Yak Posting Veteran

57 Posts

Posted - 2001-08-27 : 11:48:58
Help, I have a simple SQL agent job which call a stored procedure. The SP runs for about 45 minutes and I don't see any errors in the job output. However SQL Agent reports the job as having Failed. If I run the SP from Query Analyzer it runs fine with no errors. Any ideas on why the job is reported as failing?
Thanks for any help?



Ron Grzywacz
   

- Advertisement -