06-12-2017 11:14 AM
On a BI server using SAS Management Console to schedule LSF flows, is it possible to specify a time limit for execution a job or flow?
I have some nightly flows that hang on occassion. I don't have a root cause for the hang yet (suspect network problems / remote database connections). I would like to be able to set an option that says "If this job/flow runs for longer than X minutes, kill it."
Currently when a job hangs it just sits there with a status of running, and the next night's run does not start, and since I can't kill the job myself (sadly I don't have rights), I have to put in a ticket to get an admin to kill it. So life would be easier if when we created the flow they just specified a run time limit which would automatically kill the job.
I think it's a stripped down version of LSF that comes with EBI server. Not sure if this is possible?
06-12-2017 01:14 PM
It's grayed out. For this server, I don't actually own the flows, so I can't kill them.
The workflow is that I create a DI job, and then deploy the job, then put in a ticket for an admin to create the flow and schedule it. Since I don't own the flow, I can't kill it.
The other down side of this approach is that the SAS job doesn't run as me, it runs as some service account they use for scheduling. I can't even trigger a flow. So it's not ideal for me as a developer, but it's not my server. Maybe if I keep putting in enough tickets to kill hung jobs, they'll give me access to the service account. : )