topic Re: Job execution when a transformation fails in SAS Data Management

Job execution when a transformation fails

Sandhyaa — Fri, 07 Dec 2012 10:18:08 GMT

Is it always , when a transformation in a job fails, the successive transformations will get executed upto the job's post code?

Re: Job execution when a transformation fails

LinusH — Fri, 07 Dec 2012 16:36:24 GMT

What do you mean by "fails"?

And no, not always.

Re: Job execution when a transformation fails

Sandhyaa — Mon, 10 Dec 2012 04:30:26 GMT

By fails, i mean that, the transformation may fail for any reason, ie. a lookup table is missing or anything else like that,

error code > 0

Can you just give me a scenario where the job wont run till postcode if anything fails inbetween. Because, for all possible error scenarios, the job is running till the post code.

Re: Job execution when a transformation fails

Sandhyaa — Mon, 10 Dec 2012 04:34:40 GMT

Actually, we need to write an entry into the audit log if the job fails. Since, the job is running till postcode, we have written the code for audit log in the job's post code based on the return code value. If the job is not going to be executed till the job's post code on failure cases, then we need to handle this code at the transformation level. For this purpose only, we just want to confirm.

Re: Job execution when a transformation fails

LinusH — Mon, 10 Dec 2012 09:45:00 GMT

It could be a challenge to rely on code within a SAS sessions that has a failing step.

The risk is that it will occur a situation that is not prepared for, and not possible for at post process to log/audit.

What is the purpose?

The usual requirements are monitoring, and that should be handled outside SAS, usually by the scheduler.

Other auditing/logging: I would say this might be interesting for keeping statistics, like process time, resources consumed etc, so that you can see changes over time, making prognosis on future use etc,