Post reply

tracking the success of jobs

  • June 4, 2008 at 9:06 am

    #125534

    I know I can go into the job activity monitor to view the success of each job that last ran.

    Is there a script for this also?

    Thanks.

  • June 4, 2008 at 10:12 am

    #824317

    I'm no TSQL expert, so someone could probably write a much better script than I could, but you want to look into joining these two tables:

    [msdb].[dbo].[sysjobhistory]

    [msdb].[dbo].[sysjobs]

    "Got no time for the jibba jabba!"
    -B.A. Baracus

  • June 4, 2008 at 12:23 pm

    #824422

    thanks

    ahutch (6/4/2008)

    I'm no TSQL expert, so someone could probably right a much better script than I could, but you want to look into joining these two tables:

    [msdb].[dbo].[sysjobhistory]

    [msdb].[dbo].[sysjobs]

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

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