I've got a dbms_scheduler-Job running in Oracle 10.2.0. When I change the system date back to yesterday, the job will wait for one day to continue its work. The reason for this is that next_run_date does not change. This does not happen regularly, but sometimes someone decides to change the system date without thinking or even knowing ...
Here's a good one for any Oracle gurus out there. I'm working on a web page that dynamically configures Oracle DB backup settings in a closed environment. Right now, I have everything set up to generate scheduled jobs that run pre-determined RMAN scripts that already exist on the Database server's disk. This works, but I want to go a ste...
I want to create a job that would drop a database object at a given date. The job created all right but the procedure is not executed. Tried executing the procedure alone and it works. Here's the code for the create job v_jobnam := v_objnam; v_jobnam := DBMS_SCHEDULER.generate_job_name (v_jobnam); v_startdate := to_tim...
When this code is executed in SQL Developer against Oracle 11g I get an error, begin dbms_scheduler.create_job( job_name => 'comuni_34', job_type => 'plsql_block', job_action => 'begin com_auth_api.expire_old_passwords; end;', start_date => to_date('2009-jan-01 01:15:00', 'yyyy-mon-dd hh24:mi:ss'), repeat_interval => 'freq=dai...