Problem with SqlServerAgent job

• Barkingdog

  SSCoach

  Points: 18670

  More actions

  March 18, 2003 at 1:04 pm

  #58922

  We have a custom t-sql job (sql 2k) that failed last night:

  "SQL Server Scheduled Job 'Batch Processing' (0xE5A94529562C4A47AC95FD169C72472E) - Status: Failed - Invoked on: 3/17/2003 10:30:00 PM - Message: The job failed. The Job was invoked by Schedule 16 (Daily 10pm). The last step to run was step 1 (Batch Stored Proc). "

  I find this descprition useless. I checked sql's current activity logs and the windows event log. Nothing shed light on this matter.

  Any adivce on how to better prepare for the next one?

  TIA,

  Bill

• mybid2003

  SSCertifiable

  Points: 6620

  More actions

  March 18, 2003 at 1:06 pm

  #451376

  Bill,

  You can try outputting to a text file from the JOB. That might give more info.

  Hope this Helps!!!

  .

• Rodrigo Acosta

  SSC-Insane

  Points: 21261

  More actions

  March 18, 2003 at 1:18 pm

  #451377

  Also if you explain what does the job do would help us find the problem...