Post reply

Failed job information

  • July 10, 2008 at 2:25 pm

    #129909

    Hi All,

    I am in the process of developing a report of all the successful job and failed job for around 12 DBS. And would finally have that placed an a colorful dashboard for the management.

    I have never done that before so want to know, in which table of msdb db the job history is stored.,

    Thanks

    Dev.

  • July 10, 2008 at 2:52 pm

    #841118

    msdb.dbo.sysjobhistory

    msdb.dbo.sysjobs

    msdb.dob.sysjobschedules......

  • July 11, 2008 at 9:57 am

    #841646

    Thank you. That helped.

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

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