SQL 2000 JOB

Question

Post reply

SQL 2000 JOB

chakra-1053412

SSC Enthusiast

Points: 188
More actions
May 18, 2009 at 9:55 am

#134205

HI ALL
HOW TO FIND THE CAUSE OF A JOB FAILURE IN SQL 2000 (OTHER THAN SEEING THE JOB HISTORY)
THANK YOU
CHAKRA

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

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

Lynn Pettis SSC Guru Points: 442467 More actions · Answer 1

Lynn Pettis

SSC Guru

Points: 442467

May 18, 2009 at 9:58 am

#996448

that is where i also start when a job fails.

Pradyothana Shastry SSCertifiable Points: 5211 More actions · Answer 2

Check for your alert msg to idenify job failed or not. 🙂

- Pradyothana http://www.msqlserver.com

chakra-1053412 SSC Enthusiast Points: 188 More actions · Answer 3

HI,

in sql server log the job failure is displayed clearly.

chakra-1053412 SSC Enthusiast Points: 188 More actions · Answer 4

HI ALL,

I FOUND HOW TO VIEW JOB FAILURE. SIMPLE GO TO THE FAILED JOB CLICK VIEW JOB HISTORY, CLICK THE SHOW STEP DETAILS CHECK BOX TO SEE A DETAILED REPORT. I DON THINK ANY OTHER WAY IS THERE TO...