Post reply

A job failed with no reason

  • May 28, 2003 at 11:52 am

    #81637

    Hi,

    I have run into a problem.

    A job including several stored procedures on SQL2K worked very well for a while, but it failed two days ago.

    The message of Job History is "The job failed. The Job was invoked by Schedule 40 (dailyEvents). The last step to run was step 1 (Events). "

    The W2K Event Viewer showed me almost the same message.

    The funny thing is I run the job on QA, every thing goes smoothly and the correct result comes out. Does it mean the SPs are fine?

    If SPs are fine, why doesn¡¯t the job work? Do you have any ideas?

    Thanks for your help!

    Edited by - making Future on 05/28/2003 2:37:44 PM

  • May 28, 2003 at 12:05 pm

    #458888

    Any changes made to your job such as service pack, job owner, SQL Agent account/password, permissions if there are commands in the SP that have to access share directory?

  • May 28, 2003 at 2:40 pm

    #458919

    I use System Account for both SQL Server and SQL Server Agent. No change to dbo.

    Any other possible reasons?

    Thanks

  • May 28, 2003 at 3:27 pm

    #458920

    Open the job "Properties" dialog. Go to "Steps" and open "Edit" dialog for step one. Go to "Advanced" tab. Specify "output file" and check "Append output" checkbox. Save the changes ant try to re-run the job manually.

  • May 29, 2003 at 2:20 pm

    #459103

    I got the reason by using 'Output file'. Some date made me crazy.

    Appreciate you both.

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply