<div>
<div class="content wysiwyg-content">
Hi, 
 
I have a procedure like pr_test which takes one number type argument. 
I want to put this procedure in scheduler to run daily. 
But when I create like this 
 
BEGIN 
&nbsp; &nbsp;DBMS_SCHEDULER.CREATE_JOB ( 
&nbsp; &nbsp; &nbsp; JOB_NAME &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; 'scheld_test, 
&nbsp; &nbsp; &nbsp; JOB_TYPE &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; 'STORED_PROCEDURE', 
&nbsp; &nbsp; &nbsp; JOB_ACTION &nbsp; &nbsp; &nbsp; &nbsp;=&gt; 'pr_test (5)',--passing argument 5 
&nbsp; &nbsp; &nbsp; START_DATE &nbsp; &nbsp; &nbsp; &nbsp;=&gt; SYSTIMESTAMP, 
&nbsp; &nbsp; &nbsp; REPEAT_INTERVAL &nbsp; =&gt; 'freq=daily;byhour=1;', 
&nbsp; &nbsp; &nbsp; ENABLED &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; =&gt; FALSE, 
&nbsp; &nbsp; &nbsp; COMMENTS &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;=&gt; 'run daily once at 1 am '); 
END; 
/ 
 
Its &nbsp;not taking the argument 1 and throwing the error as invalid object. 
Can you please let me know how can I schedule the job? 
 
Thanks
</div>
</div>

Hi,

I have a procedure like pr_test which takes one number type argument.
I want to put this procedure in scheduler to run daily.
But when I create like this

BEGIN
   DBMS_SCHEDULER.CREATE_JOB (
      JOB_NAME          => 'scheld_test,
      JOB_TYPE          => 'STORED_PROCEDURE',
      JOB_ACTION        => 'pr_test (5)',--passing argument 5
      START_DATE        => SYSTIMESTAMP,
      REPEAT_INTERVAL   => 'freq=daily;byhour=1;',
      ENABLED           => FALSE,
      COMMENTS          => 'run daily once at 1 am ');
END;
/

Its  not taking the argument 1 and throwing the error as invalid object.
Can you please let me know how can I schedule the job?

Thanks

DBMS_SCHEDULER.CREATE_JOB

Hi,

I have a procedure like pr_test which takes one number type argument.
I want to put this procedure in scheduler to run daily.
But when I create like this

BEGIN
   DBMS_SCHEDULER.CREATE_JOB (
      JOB_NAME          =&gt; &#39;scheld_test,
      JOB_TYPE          =&gt; &#39;STORED_PROCEDURE&#39;,
      JOB_ACTION        =&gt; &#39;pr_test (5)&#39;,--passing argument 5
      START_DATE        =&gt; SYSTIMESTAMP,
      REPEAT_INTERVAL   =&gt; &#39;freq=daily;byhour=1;&#39;,
      ENABLED           =&gt; FALSE,
      COMMENTS          =&gt; &#39;run daily once at 1 am &#39;);
END;
/

Its  not taking the argument 1 and throwing the error as invalid object.
Can you please let me know how can I schedule the job?

Thanks

Oracle is an object-relational database management system. It supports a large number of languages and application development frameworks. Its primary languages are SQL, PL/SQL and Java, but it also includes support for C and C++. Oracle also has its own enterprise modules and application server software.