SQLAgent - TSQL JobStep (Job 0x9346BC42AD13350A939B9557A : Step 1) 

SELECT * FROM sysjobs
WHERE job_id LIKE '%0x9346BC42AD13350A939B9557A%'

SELECT * FROM sysjobsteps
WHERE job_id LIKE '%0x9346BC42AD13350A939B9557A%'

SELECT
instance_id
,job_id
,step_id
,step_name
,run_time
, run_time/10000 AS run_time_hours
, (run_time%10000)/100 AS run_time_minutes 
, (run_time%10000)%100 AS run_time_seconds
, (run_time/10000 /*run_time_hours*/ * 60 * 60 /* hours to minutes to seconds*/)
+ ((run_time%10000)/100 /* run_time_minutes */ * 60 /* minutes to seconds */ )
+ (run_time%10000)%100 AS run_time_elapsed_seconds
, CONVERT(DATETIME, RTRIM(run_date)) AS Start_Date
, CONVERT(DATETIME, RTRIM(run_date)) + 
((run_time/10000 * 3600) + ((run_time%10000)/100*60) + (run_time%10000)%100 /*run_time_elapsed_seconds*/) / (23.999999*3600 /* seconds in a day*/) AS Start_DateTime
, ((run_duration/10000 * 3600) + ((run_duration%10000)/100*60) + (run_duration%10000)%100 /*run_duration_elapsed_seconds*/)
, CONVERT(DATETIME, RTRIM(run_date)) + ((run_time/10000 * 3600) + ((run_time%10000)/100*60) + (run_time%10000)%100) / (86399.9964 /* Start Date Time */)
+ ((run_duration/10000 * 3600) + ((run_duration%10000)/100*60) + (run_duration%10000)%100 /*run_duration_elapsed_seconds*/) / (86399.9964 /* seconds in a day*/) AS End_DateTime
FROM msdb.dbo.sysjobhistory
where job_id like convert(uniqueidentifier,0x9346BC42AD13350A939B9557A)

Или так
select * from sysjobsteps
WHERE job_id like convert(uniqueidentifier,0x9346BC42AD13350A939B9557A)

/*
SQLAgent - TSQL JobStep (Job 0xB5B4EEB3721EB344AF07CD5C1F0AC778 : Step 1)                                                       
*/

select
    count(*)
from    msdb.dbo.sysjobs  a
where
    a.job_id = 0xB5B4EEB3721EB344AF07CD5C1F0AC778

-----------
1

select convert(uniqueidentifier,0x9346BC42AD13350A939B9557A)
------------------------------------
C46B3409-D12A-5033-A939-B9557A000000