table which keep tracks of chron jobs history

Hi,

We schedule the pl/sql procedures and queries through cron jobs.

for example if you run any .sql script(contains 2 to 3 actions i.e queries,procedures ),it will produce an output saying "procedure ran sucessfully"....."23456 rows inserted succesfully" etc etc..

the cron jobs will produce the logfiles where we can check whether that particular job ran successfully or not.

The same thing i want to see in the form of oracle table which keep track of job name,when the job has ran succesfully,at what time etc etc..

so that we will have the history of the jobs in a table having information like at what time what all jobs has ran successfully.

how can we pass this information to a oracle table..

I know that the errors can be collected by making use of exceptions where we will make use of procedure.

how about the succesful commands????

Thanks,
Sappi Received on Wed May 10 2006 - 19:20:01 CDT