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'
==============

• Next in forum: Re: SQL 2005 Management Studio Bugs
• Prev in forum: Re: Incorrect Syntax using IF statement
• Thread view: Re: Incorrect Syntax using IF statement

[Reply to this message]