I am looking for a way to kill jobs that are showing the ! warning symbol after so many hours like 48 hours. I have a SQL script that pulls them but not with consistency as my search may be wrong. I would like to do this with a workflow or QScript.
If you ever interested in another way of achiving it , it'd be done via scheduling -> backup task options -> Advance backup options -> Job rettry -> Enable total running time.