Hi everybody.
I am calling an SQL Server Stored Procedure through a job DataStage and, at the end of its execution, the job always finishes ok, independent on the Stored Procedure result.
I can see its Output variable by the Peek - at the log - but I can take any action about it.
I would like to provoke a warning in case of problems with the Procedure Execution. If there is a problem when execute an Update operation at the Proc, the RAISERROR doesn't appear at the Datastage log and there is no log to report it, only the Output variable tells me there is a problem.
The user must be notified and the job must finish with warnings or aborted.
How could I do this?
PS. I prefer not to use those rules to message handler.
Thank you very much,
Force a warning depending on Procedure Execution Result
Moderators: chulett, rschirm, roy
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
Force a warning depending on Procedure Execution Result
Joyce A. Recacho
São Paulo/SP
Brazil
São Paulo/SP
Brazil
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
-
- Participant
- Posts: 298
- Joined: Tue Aug 26, 2008 12:17 pm
Hi friends.
I used the transformer to read the output from the Procedure and then, I directed this output to two peeks. One of them is to identify the problem. If a row passes by that link, the job aborts. I informed this action at the option: 'Abort After Rows' - I informed one row.
So, when the job aborts, there is an error log with the Procedure Return at the Director.
Thanks Guys.
Joyce
I used the transformer to read the output from the Procedure and then, I directed this output to two peeks. One of them is to identify the problem. If a row passes by that link, the job aborts. I informed this action at the option: 'Abort After Rows' - I informed one row.
So, when the job aborts, there is an error log with the Procedure Return at the Director.
Thanks Guys.
Joyce
Joyce A. Recacho
São Paulo/SP
Brazil
São Paulo/SP
Brazil