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?
Thx.
The Kill option in LSF Process Manager - is it grayed out for you or does it just not work?
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. : )
My user account is defined as an LSF admin account and I can kill other users jobs. Maybe you could request that.
SAS Innovate 2025 is scheduled for May 6-9 in Orlando, FL. Sign up to be first to learn about the agenda and registration!
Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.
Find more tutorials on the SAS Users YouTube channel.