I'm getting an error in s01-Job Last Run Datetime. It's a syntax error near '(' in this code. I'm not familiar with the $(ESCAPE_NONE(JOBID)) portion of the statement.

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

I really like what you've done & want to make this work for me too.

Thanks