Home » SQL & PL/SQL » SQL & PL/SQL » runing sql script periodically (OS-windows NT, oracle 10.2)
runing sql script periodically [message #399679] Thu, 23 April 2009 08:08 Go to next message
Messages: 184
Registered: November 2007
Location: Bangalore
Senior Member

I need to run a .sql script every 1 hour. Can any one tell some utility or way to do it?

I tried dbms_job.submit


v_job number;
sys.dbms_job.submit(job => v_job,what => '@x.sql;',next_date => sysdate,interval => 'sysdate + 1/24');

It is giving an error as encountered symbol @ when expecting.....

please help
Re: runing sql script periodically [message #399680 is a reply to message #399679] Thu, 23 April 2009 08:15 Go to previous message
Michel Cadot
Messages: 65154
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Put the statements in a procedure or an anonymous PL/SQL block and execute it.
Or use dbms_scheduler.
Now not all is possible, it depends on what you want to do inside the script.

Previous Topic: UTL_FILE and invalid directory path
Next Topic: data to be inactive
Goto Forum:

Current Time: Wed Aug 23 01:13:24 CDT 2017

Total time taken to generate the page: 0.05254 seconds