Job Failure

[justusjillella]

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.?

[Kurt_Bremser]

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.

[justusjillella]

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.

[r_behata]

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&docset...

[justusjillella]

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

[SASKiwi]

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. 

[LinusH]

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.