I have requirement where i need to perform some actions from my sql agent job if other sql job is currently running , i dont find the way to figure out currently executing sql job as it looks like only syshistory is the way but that tells me only last execution runtime etc , is there any way i can have the information from T-SQL other than openrowset?
Thanks!!