Posted by Fergatron on 04/06/06 16:57

Thanks, I played with it a bit and I got the result I was looking for.

==============
USE msdb
DECLARE @JobName varchar(255)
SELECT @JobName = name FROM sysjobs WHERE name = 'Scheduled Nightfax'

IF @JobName = 'Scheduled Nightfax'
PRINT 'YES'
ELSE
PRINT 'NO'
==============

[Back to original message]