Thanks Adiga and Alex for your response, Adiga that script is good but not solving my purpose 🙁 .

Alex there must be some way to get a value from sp_help_job (variable or temp table). I am not very good in scripting that’s why struggling.

thanks,

DKG