Post reply

Error Details of a job

  • July 16, 2008 at 8:13 am

    #71641

    HI,

    I schduled a job and it failed today.where should i check for the details of why the job is failed?

    Thanks

  • July 16, 2008 at 9:34 am

    #843889

    In Enterprise Mangager -> Management -> SQL Server Agent -> Jobs: right-click on the job and select "view job history...". Check the "Show step details" box on the Job Hisory screen and click on the failed step. This will display the error message for the failure.

    Greg

  • July 16, 2008 at 10:29 am

    #843924

    Sometime, you need to check error log or job log (if you have one).

  • July 21, 2008 at 5:21 am

    #845679

    You can change the job name in the below query and execute it to get the job history.

    EXEC msdb.dbo.sp_help_jobhistory @job_name='Your Jobname'

    Regards..Vidhya Sagar
    SQL-Articles

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

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