This discussion is archived
5 Replies Latest reply: Sep 18, 2012 5:46 AM by user12183227 RSS

Sending the output of scheduler job to few mail ids.

user12183227 Newbie
Currently Being Moderated
Hi

We are having the below database version on a Solaris machine.

Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - Prod
PL/SQL Release 10.2.0.3.0 - Production
CORE 10.2.0.3.0 Production
TNS for Solaris: Version 10.2.0.3.0 - Production
NLSRTL Version 10.2.0.3.0 - Production

I am new to scheduling jobs and having a task of scheduling a job using DBMS_SCHEDULER. The job action run one of the procedure belong to another user. The execution of procedure insert few values into a table. Below is the job I had scheduled. Just let me know if anything wrong is there in the setup.

================================================


BEGIN
DBMS_SCHEDULER.create_job (
job_name => 'ILPS_PRSP_DMS_CYCLE_REPORT',
job_type => 'PLSQL_BLOCK',
job_action => 'ILPS.PRSP_DMS_CYCLE_REPORT.DMS_CYCLE_REPORT',
start_date => SYSTIMESTAMP,
repeat_interval => ‘freq=daily; byhour=8; byminute=0; bysecond=0;’,
end_date => NULL,
enabled => TRUE,
comments => 'Job defined entirely by the CREATE JOB procedure.');
END;
/


=================================================
Schema: ILPS
Procedure:PRSP_DMS_CYCLE_REPORT
Table: DMS_CYCLE_REPORT

Now my question is the records or output generated in the table DMS_CYCLE_REPORT need to be send to few concern people mail ids. How I can do that. Do i need to spool the activity ? After completing the job how the output of table can be send to people by mail ?

Thanks
SHIYAS M

Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points