Regarding Execution [message #947] |
Thu, 14 March 2002 20:49 |
Dhinakaran
Messages: 3 Registered: March 2002
|
Junior Member |
|
|
Hai
I want to execute the SQL query in a schedule basis like windows Scheduler.
For example I will set a time 12.00AM to execute a particualr query.
Is these possible in Oracle? if so please guide me how to get solution for the same.
regards
Dhinakaran
|
|
|
Re: Regarding Execution [message #949 is a reply to message #947] |
Thu, 14 March 2002 23:26 |
pratap kumar tripathy
Messages: 660 Registered: January 2002
|
Senior Member |
|
|
1.create a procedure and include the sql statement within it.
2. create a database job using dbms_job package and put the procedure in the job queue.
see the documentation for details about dbms_job package
|
|
|