Skip to content


Force stop a long running Map automatically

Manny asked 2 years ago
Is there a way to force stop a scheduled Map job that has been running longer than usual?   We have one MAP that runs once every 24 hours.  The job itself should only take about 1 hour.  If it’s longer than this, then that means something went wrong.  Then the next day it won’t run again because the job is “locked” by the “system” account.  So we don’t get any notification that it’s not running.   I have to open the Map and clear the lock so I can open the Map and manually run it.  It usually runs fine the next day too.  Just once in a blue moon, it gets stuck.  If we don’t check to see that it’s stuck… it stays like that for days until an end user sees missing/wrong data.
So…I’d like to know if we can put a 2 hour timeout on a job that will force clear the lock. So that It can run again the next day. 
Patrick Roth Staff answered 2 years ago
There isn’t anything built-in that does this.
However you could write a SQL job to run every X hours that would delete from that table for records that are however old you want to check for.
Manny replied 2 years ago

Thanks. Which table is this?

Patrick Roth Staff replied 2 years ago


If you would like to submit an answer or comment, please sign in to the eOne portal.