Post reply

Jobs in sql server 2005

  • April 19, 2007 at 3:09 am

    #370600

    Sorry if i posted in the wrong place.

    We have a job in sql server that runs a stored proc every night, I can see that it failed last night under the sql server agent tab but is there any way of knowing why it failed... some log file with the error maybe?

    Thanks

    CK

  • April 19, 2007 at 4:25 am

    #701370

    Best point to start investigating any job failures is always the jobhistory.

    Right click your job and select view history. Usually it will give you the reason why a job failed.

    Markus

    [font="Verdana"]Markus Bohse[/font]

  • April 19, 2007 at 4:59 am

    #701384

    nice you Markus

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

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