I have created a stored procedure that I run that refreshes some tables. I run it and it works successfully. I have scheduled the job to run every 15 minutes using the following SQL:
I can query the USER_JOBS table and I see the job is scheduled and not broken. I then force the job to run the first time with the following:
The procedure completes successfully and the next run time is incremented. But, if I wait until that time has come and gone, the job does not run as scheduled. Any ideas what I am doing wrong? Terry
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...
Code:
VARIABLE jobno number;
BEGIN
DBMS_JOB.SUBMIT(:jobno,
'ehgriff.refresh_static_tables;',
SYSDATE,
'SYSDATE + 1/96');
commit;
END;
Code:
exec dbms_job.run(14);
**************************
* General Disclaimor - Please read *
**************************
Please make sure your post is in the CORRECT forum, has a descriptive title, gives as much detail to the problem as possible, and has examples of expected results. This will enable me and others to help you faster...