We have rule in schedule updates.
This rule generally takes 2-3 hours to complete.
But here rule is taking long time sometimes goes to 24 hrs and more and show status = running.
So is there way that this refresh gets cancelled after certain time.
Is there anything we can do server config file.
Please someone suggest solution for this as this is happening frequently. We are required to do unnecessary manual monitoring even on weekends which is really frustrating.
A general timeout value for each rule would be a nice thing to get out of situations where an update/load job takes longer than anticipated for whatever reason (data source hickup, system message lost etc).
As long as the next planned update will be run according to scheduled there is often no big issue if one update is discarded (e.g."the update every 15 min during business hours" usecase).
For the situations where this happens during the "expensive one load per week" use-case, the retry mechanism should kick in as a normal cancel/failure situation.