AnsweredAssumed Answered

Stored procedure "jobs" output

Question asked by Dave_3.0 Champion on Sep 2, 2015
Latest reply on Sep 3, 2015 by Dave_3.0

I probably should know the answer to this*, but is it possible to get diagnostic / informative messages out of custom stored-procedure jobs (PL/SQL or T-SQL database procedures) that is then visible in the application job history (online, not in the log files, although I guess I could live with the log files)?


So what I want to do is have run a stored-procedure type job and have a visible message in the logs saying "Processed 26 records, 3 errors" sort of thing - I know I could do something with a custom table and a custom portlet to read that table, just wondering if there is anything better integrated into the existing system?

 

* - OK, I think the answer is "no" but just in case I'm missing something...

 

 

Outcomes