Get running job name from sysprocesses
Get the substring of the running job from sysprocess .. have filtered out generic refresher ETC select substring(program_name,55,7) ‘to search’ from master..sysprocesses where program_name like ‘%agent%’ and program_name not like ‘%DatabaseMail – SQLAGENT -%’...