Using The JOBID Token In 2005

$(ESCAPE_NONE(JOBID))

Here is the skinny. You can use this in a script from what I have done so far. If someone gives it a try in a stored procedure let me know. From what I have seen you can pass the token as uniqueidentifier. The problem is when you try to use it in a query you need to use Convert(char255, JOBID).

Here is a simple example:

declare @JobID uniqueidentifier
declare @result varchar(1000)
SELECT @JobID = $(ESCAPE_NONE(JOBID));
PRINT 'Hi there ' + Convert(char(255), @JobID)

I searched all over the place and nowhere did I find something like the above. It seems simple but you can do a select in a table like sysjobhistory without converting the jobid first. Let me know if this helps anyone.

Thanks