topic Re: SAS LSF job re-run if failed in Administration and Deployment

SAS LSF job re-run if failed

freshstarter — Tue, 28 May 2024 15:35:34 GMT

Hello,

I have a deployed SAS job runs in flow which always fails during the first run and after we re -run manually it will get succeeded. The issue is due to sql server stored procedure which we call in it in the SAS job.

So we thought of adding exception handling in the schedule manager for that job. We have defined that 'if the job fails with exit code greater than zero, we asked it to re-run automatically', But its not working. Is there any other way to remove the manual process of re run ?

Thanks

Re: SAS LSF job re-run if failed

gwootton — Tue, 28 May 2024 18:15:37 GMT

Your solution of running the job again if it fails sounds valid. Do you have any details on how it isn't working?
Could you modify your code to retry a failed call to the stored procedure?

Re: SAS LSF job re-run if failed

SASKiwi — Tue, 28 May 2024 20:00:37 GMT

I suggest you talk with your SQL Server database administrator to see if you can get the stored procedure fixed. It's always better to cure the disease rather than treat the symptoms.

Re: SAS LSF job re-run if failed

ballardw — Tue, 28 May 2024 22:24:30 GMT

What sort of problem does SAS report with the stored procedure?

If the procedure is taking too long to respond to data request from SAS perhaps you just need to add a bit of code to have SAS wait for the procedure.

Or maybe your connection options between SAS and SQL Server need to be tweeked a bit.

Re: SAS LSF job re-run if failed

CHandberg — Wed, 29 May 2024 13:08:26 GMT

Does the job exit with an error or a warning?

If it's an error i'll agree with the other suggestions to fix the error by its source.

If it' a warning, and you want to allow your batch-flows to complete with a warning, then you can edit the sasbatch.bat file.

\SAS\Config\Lev1\SASApp\BatchServer\sasbatch.bat

Just remove the REM in the last four lines as stated in the comments in the file.

This is on a windows platform but I assume that you can do something similar if it's another platform.