Avatar of GouthamAnand
GouthamAnand
 asked on

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          => '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
Oracle Database

Avatar of undefined
Last Comment
GouthamAnand

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
johnsone

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
GouthamAnand

ASKER
Thank you very much.
This is the best money I have ever spent. I cannot not tell you how many times these folks have saved my bacon. I learn so much from the contributors.
rwheeler23