to get daily reports on Jobs scheduled

[talk2daa]

all,

i have 5 jobs running on midnight daily basis . how can i view the reports of this job if this job completed or failed?

can we set email alert or something

 

[Claus Pedersen]

1) use a log table where you log the status of the job, time of completion, rows handled etc.

2) catch the job execution in a exception block, if job runs successfully, insert success into the log table, on exception, insert failure into the log table

3)use Oracle package utl_smtp to send emails with the result of the jobs