3 Replies Latest reply on Jan 15, 2010 8:09 PM by 703782

    Job with multiple event schedules

    703782
      Is it possible to create a job with multiple schedules? Can you have multiple schedule names?

      DBMS_SCHEDULER.CREATE_JOB (
      job_name => 'my_new_job2',
      job_type => 'PLSQL_BLOCK',
      job_action => 'BEGIN SALES_PKG.UPDATE_SALES_SUMMARY; END;',
      schedule_name => 'my_saved_schedule, my_saved_schedule2'); <------------------ like this?
      END;


      thanks.