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

    Sending the output of scheduler job to few mail ids.

    user12183227
      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