Job Id for job which is being executed

• sa24

  SSCrazy Eights

  Points: 8027

  More actions

  October 24, 2002 at 12:44 pm

  #79248

  I think that this is not a smart question. But can someone help me to know the jobid of a job from within a job which is executing.

• Andy Warren

  SSC Guru

  Points: 119902

  More actions

  October 24, 2002 at 6:40 pm

  #439415

  Not a dumb question. Dont see a simple way. Probably could use the spid to query sysprocesses, use that to look up in sysjobs.

  Andy

  http://www.sqlservercentral.com/columnists/awarren/

  Andy
  SQLAndy - My Blog!
  Connect with me on LinkedIn
  Follow me on Twitter

• akshay1974

  SSC-Addicted

  Points: 444

  More actions

  October 24, 2002 at 9:57 pm

  #439425

  Thanks Andy. I thought there would had been an easy way out. But thanks for the help.