Post reply

How to trace job id using sql server profiler

  • April 21, 2014 at 12:17 pm

    #306887

    Hi....guys,

    We are running Stored procedure using SQL Server Agent.

    We need to trace job id of particluar SQL Server Agent job through SQl Server profiler

    reply....thnx

  • April 21, 2014 at 4:21 pm

    #1707585

    I'm pretty sure there's no way to trace by JobId. But, you can trace by application name, so that will make it so you only ever get calls from SQL Agent. That should be a relatively small amount of data collected. But, you do know you're better of using extended events if you need to do specific filtering because it filters before it captures events instead of after like trace.

    "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
    - Theodore Roosevelt

    Author of:
    SQL Server Execution Plans
    SQL Server Query Performance Tuning

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

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