5 Replies Latest reply: Sep 18, 2012 7:46 AM by user12183227 RSS

    Sending the output of scheduler job to few mail ids.


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

      Oracle Database 10g Enterprise Edition Release - Prod
      PL/SQL Release - Production
      CORE Production
      TNS for Solaris: Version - Production
      NLSRTL Version - 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.


      DBMS_SCHEDULER.create_job (
      job_name => 'ILPS_PRSP_DMS_CYCLE_REPORT',
      job_type => 'PLSQL_BLOCK',
      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.');

      Schema: ILPS

      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 ?

      SHIYAS M