This discussion is archived
2 Replies Latest reply: Jan 6, 2013 10:33 PM by 970843 RSS

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

970843 Newbie
Currently Being Moderated
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

Legend

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