12-09-2012 11:30 PM
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.
12-09-2012 11:34 PM
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.
12-10-2012 04:45 AM
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,