Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- DECLARE @JobName varchar(max)
- SELECT @JobName = [name]
- FROM msdb.dbo.sysjobs WHERE job_id = cast(0xC40A7398C611704CA9F2EA1EEFBD9B33 AS uniqueidentifier)
- EXECUTE msdb..sp_help_job @job_name = @JobName
- EXECUTE msdb..sp_help_jobstep @job_name = @JobName
Add Comment
Please, Sign In to add comment