Post reply

SQL JOB History & JOB Activity

  • June 25, 2012 at 6:53 am

    #263308

    Hi All,

    I am working on a SQL JOB History & JOB Activity tables, to get the Job Status of the Job Submitted by a User using "sp_start_job" with Specific Job Name & Step Name.

    Need help on Few Points:

    1. Best way to Capture the Job Row which has been Submitted by the user.

    a) Session ID

    b) Instance ID etc....!

    2. How is the data moved / Sync from job activity to history (Logic)

    Please need your help.....!

  • June 25, 2012 at 8:05 am

    #1505067

    1. Create an Extended Events session to capture execution information regarding sp_start_job.

    2. It doesn't get moved. They are both updated individually.

    My blog: SQL Soldier[/url]
    SQL Server Best Practices:     SQL Server Best Practices
    Twitter: @SQLSoldier
    My book: Pro SQL Server 2008 Mirroring[/url]
    Microsoft Certified Master: SQL Server, Data Platform MVP
    Database Engineer at BlueMountain Capital Management[/url]

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

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