This content has been marked as final. Show 4 replies
You have two options.
1) Oracle job scheduler
2) Windows Tasks
Oracle job scheduler you can run it by your requirement. you can create it like below:-
Above job will run on 8pm daily.
begin DBMS_SCHEDULER.CREATE_JOB( JOB_NAME => 'JOB_FOR_TEST', JOB_TYPE => 'PLSQL_BLOCK', JOB_ACTION => 'begin YOUR_PROCEDURE_NAME; end;', START_DATE => SYSTIMESTAMP, END_DATE => NULL, COMMENTS => 'JOB IS CREATED FOR TEST ONLY.', ENABLED => TRUE, REPEAT_INTERVAL => 'freq=daily; byhour=20; byminute=0; bysecond=0;'); end; /
likewise since i dont know whether you are on windows or linus or unix etc... you can scheduler windows level tasts...
I have a question why would you create the same DDL and DML every day?.If you are seeking automation you can use the DBMS scheduler or write a shell script and grant it the execute permission and then schedule it daily or weekly in the crontab job.