How might I go about logging the result of an automated sql script and or pl/sql procedure in oracle sql developer in a custom table?
I'd like to capture:
success or failure of the script/query, error code if present, date time of completion and the target table for insertion.
We are using stone branch to automate the jobs and can see each query result there, but cannot see a consolidated result of 12 daily scheduled jobs.