Return to Answer

Code block and formating

Source Link

edit approved Mar 3, 2017 at 14:28

2.1k
3
21
34

select TOP 1 job_id from msdb.dbo.sysjobs WHERE category_id IN (SELECT category_id FROM msdb.dbo.syscategories WHERE name = 'REPL-LogReader')

select TOP 1 job_id 
from msdb.dbo.sysjobs 
WHERE category_id IN (SELECT category_id 
                      FROM msdb.dbo.syscategories 
                      WHERE name = 'REPL-LogReader')

select TOP 1 job_id from msdb.dbo.sysjobs WHERE category_id IN (SELECT category_id FROM msdb.dbo.syscategories WHERE name = 'REPL-LogReader')

select TOP 1 job_id 
from msdb.dbo.sysjobs 
WHERE category_id IN (SELECT category_id 
                      FROM msdb.dbo.syscategories 
                      WHERE name = 'REPL-LogReader')

Source Link

created Mar 3, 2017 at 13:30

Sharon

select TOP 1 job_id from msdb.dbo.sysjobs WHERE category_id IN (SELECT category_id FROM msdb.dbo.syscategories WHERE name = 'REPL-LogReader')