Hi
I have a dbms_scheduler job that runs a SP, this SP requires 2 parameters passing to it (p_from_date and p_to_date). I have set my argument as below.
dbms_scheduler.define_program_argument
( program_name => 'PGM_PROCESS_EXCEPTIONS'
, argument_name => 'p_from_date'
, argument_position => 1
, argument_type => 'DATE'
, default_value => sysdate - 30
);
dbms_scheduler.define_program_argument
( program_name => 'PGM_PROCESS_EXCEPTIONS'
, argument_name => 'p_to_date'
, argument_position => 2
, argument_type => 'DATE'
, default_value => sysdate
);
My problem is that the default values are set to the dates when i compile this on the DB. How can i set these parameters as running parameters, as in the dates are set at the time of the job running?
Can this be done using SET_JOB_ARGUMENT_VALUE?
Cheers
Gary