topic Re: Job Failure in SAS Enterprise Guide

Job Failure

justusjillella — Thu, 18 Apr 2019 16:49:42 GMT

Hi,

Can anyone tell how does someone who is supporting a job know if it fails in the prod environment. Is any code included in every program to notify him automatically or the admin department notify him.?

Re: Job Failure

Kurt_Bremser — Thu, 18 Apr 2019 17:21:19 GMT

The code is written in such a way that it will end the SAS process with a non-zero return code if it encounters a problem. On top of that, the wrapper shell script searches the log for things that might indicate a problem, and deliver a non-zero return code if SAS did not do so on its own.

Re: Job Failure

justusjillella — Thu, 18 Apr 2019 17:41:02 GMT

Hi Kurt,

Thanks for the reply. Can you elaborate on what you mean by "non-zero return code if it encounters a problem". I'm a newbie to SAS

hope you don't mind.

Re: Job Failure

r_behata — Thu, 18 Apr 2019 18:29:55 GMT

Can you be more specific about how the Job is being executed in the production environment ? Is it triggered from a scheduler like LSF / Autosys etc. ? What is the OS ?

As mentioned by @Kurt_Bremser If you are using a Shell Wrapper script , A Non-Zero Return code will be passed on to your scheduler and based on the configuration in your environment a notification might be be triggered to the production support in an event of a failure

Also, SAS Provides Automatic Macro variables which contain the Return codes. The &SYSCC in particular can be very useful as always captures the highest value as the Return code on exit.

Here is link to the documentation :

https://documentation.sas.com/?docsetId=hostunx&docsetTarget=n16qiuy9np34a6n1pzjzn9943v7f.htm&docsetVersion=9.4&locale=en

Re: Job Failure

justusjillella — Thu, 18 Apr 2019 19:01:51 GMT

Thanks for the reply. The job is triggered from LSF in UNIX

Re: Job Failure

LinusH — Fri, 19 Apr 2019 16:57:51 GMT

Then LSF should manage this for you. Except for a job/flow will halt, you need to configure/develop something that also sends the event to someone/-thing.

Re: Job Failure

SASKiwi — Fri, 19 Apr 2019 22:42:54 GMT

You can configure LSF jobs to send emails if there is any error. Check out the job properties in SAS Management Console. We use this ourselves and it works a treat.