Forum Replies Created

Viewing post 1 (of 1 total)

  • RE: Decrypting program name from sysprocesses for agent job

    Try below script:

    declare @jobhexid varchar(100)
    set @jobhexid ='SQLAgent - TSQL JobStep (Job 0xD03E45C412E25C4CB7862EB7762F5023 : Step 3'

    select * FROM [msdb].[dbo].[sysjobs]
    WHERE CONVERT(NVARCHAR(MAX), CONVERT(VARBINARY, job_id), 1) = SUBSTRING(@jobhexid,CHARINDEX('0x',...

Viewing post 1 (of 1 total)