2 Replies Latest reply: Jan 7, 2013 12:33 AM by 970843 RSS

    Examples to create  job in a single call w/o using existing pgm or Schedule

    970843
      Hi,
      1.)I need an example to create a job in a single call without using an existing program or schedule.Below is the syntax for it and i am not finding the example program anywhere, please post some examples on it.

      DBMS_SCHEDULER.CREATE_JOB (
      job_name IN VARCHAR2,
      job_type IN VARCHAR2,
      job_action IN VARCHAR2,
      number_of_arguments IN PLS_INTEGER DEFAULT 0,
      start_date IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
      repeat_interval IN VARCHAR2 DEFAULT NULL,
      end_date IN TIMESTAMP WITH TIME ZONE DEFAULT NULL,
      job_class IN VARCHAR2 DEFAULT 'DEFAULT_JOB_CLASS',
      enabled IN BOOLEAN DEFAULT FALSE,
      auto_drop IN BOOLEAN DEFAULT TRUE,
      comments IN VARCHAR2 DEFAULT NULL);


      2.)<CREATE OR REPLACE PROCEDURE p_enqueue(msg IN VARCHAR2)
      I am having an input parameter in the procedure i have created, how to pass input value to the argument.I used "set_job_argument_value" but its throwing " invalid value 1 for attribute ARGUMENT_POSITION">

      Thanks in advance