I have a Data Studio Web Console job which invokes a stored procedure - a simple CALL PROCNAME(); is the only statement in my job.
I would like to be able to signal back to DSWC when the stored procedure encounters any warning or error conditions during its run so that DSWC would know to send me a notification...
- DSWC does not have a "warning" condition for notifications, only succeed or fail... so I guess the "warning" is not going to work.
- DSWC seems to disregard the stored procedure return value. I tried returning values like -1, -2 from my stored procedure, but DSWC just assumed "success" regardless of the stored procedure return value.
- The only way I seem to be able to trigger DSWC job fail condition is by SIGNALing a SQLEXCEPTION from the procedure. This, however, makes the whole CALL statement a failed (and thus eligible for a ROLLBACK) transaction, does it not? This is not what I have in mind.
Is this pretty much it, or am I missing something?