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
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 ');
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?