Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Extended events script to monitor a job - SQL Server 2008-2008 R2

    Hi

    DECLARE @JobName NVARCHAR(128) = 'Test';

    DECLARE @Predicate NVARCHAR(MAX)='';

    DECLARE @sqlcmd NVARCHAR(MAX)='';

    SET @sqlcmd ='IF EXISTS(SELECT * FROM sys.server_event_sessions WHERE name=''TrackResourceWaits'')

    DROP EVENT SESSION [TrackResourceWaits] ON SERVER;

    CREATE EVENT SESSION [TrackResourceWaits] ON...

Viewing post 1 (of 1 total)