Job Instance ID

• dwilliscp

  SSCrazy Eights

  Points: 9270

  More actions

  October 26, 2012 at 8:25 am

  #270201

  Does anyone know if there is a function [like getdate()] that you can use to get the Job's instance ID, if the stored proc is running under a Job? The only way I know would be to do a search on the Job and Max(instance_ID).

• Sean Pearce

  SSCoach

  Points: 15999

  More actions

  October 30, 2012 at 5:33 am

  #1554100

  This code will get the value when run in a job.

  DECLARE @MaxID INT;

  SELECT @MaxID = MAX(instance_id)

  FROM [msdb].[dbo].[sysjobhistory]

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

  AND step_id = 1;

  

  The SQL Guy @ blogspot[/url]

  @SeanPearceSQL

  About Me[/url]