• Hello

    I am getting this error at job step s01:

    Msg 102, Level 15, State 1, Line 5

    Incorrect syntax near '('.

    -- Get Job Name

    SET nocount ON

    DECLARE @JobName sysname

    SELECT @JobName = [name] FROM msdb.dbo.sysjobs

    WHERE Job_id = CONVERT(uniqueidentifier, $(ESCAPE_NONE(JOBID)))

    PRINT '>'+@JobName+'<'

    Any ideas? I am running SQL 2005 9.0.3159 32 bit