Guest User

Untitled

a guest
Apr 16th, 2018
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
T-SQL 0.37 KB | None | 0 0
  1. DECLARE @JobName varchar(max)
  2.  
  3. SELECT @JobName = [name]
  4. FROM msdb.dbo.sysjobs WHERE job_id = cast(0xC40A7398C611704CA9F2EA1EEFBD9B33 AS uniqueidentifier)
  5. EXECUTE msdb..sp_help_job @job_name = @JobName
  6. EXECUTE msdb..sp_help_jobstep @job_name = @JobName
Add Comment
Please, Sign In to add comment