SQL Server Profiler grabbed the job code sqlagent-tsql JobStep, binary job name into the field string job name, job_id

SQL Server Profiler caught a lot of code in the job, applicationname similar to Sqlagent-tsql JobStep (Job 0x94b9b5c016e8d94fb50898c868314d08:st EP 1) Such a

Need to convert the binary name in the job into job_id

The conversion is done in the following ways:

Declare @JobID uniqueidentifierSELECT @JobID = 0x94b9b5c016e8d94fb50898c868314d08PRINT 'My JobID is' + Convert(Char(255),@JobID)  Select *  fromMsdb.dbo.sysjobswherejob_id=Convert(Char(255),@JobID)

SQL Server Profiler grabbed the job code sqlagent-tsql JobStep, binary job name into the field string job name, job_id