Home » Fusion Middleware & Colab Suite » Weblogic & Application Server » Automatic execute a store procedure.
Automatic execute a store procedure. [message #76484] Sun, 25 August 2002 20:35 Go to next message
Sock Wai
Messages: 1
Registered: August 2002
Junior Member
hi,
I am trying to execute a store procedure automatically and need help.

I have a store procedure which require to run on each monday. Each time I run the store procedure I need to manually run it, is there anyway that oracle can automatically run the store procedure.

I am very new to oracle. Thank you for your help.
Re: Automatic execute a store procedure. [message #76514 is a reply to message #76484] Fri, 04 October 2002 17:08 Go to previous messageGo to next message
andrew again
Messages: 2577
Registered: March 2000
Senior Member
In sqlplus:

set serveroutput on
declare
   l_job number;
begin
    dbms_job.submit( job => l_job,
                     what => 'your_procedure;',
                     next_date => sysdate, 
                     interval => 'next_day(trunc(sysdate), 'MON') + 17/24 /* 5pm on Monday */' );
    commit;
    dbms_output.put_line( ' your job is # '|| l_job);
end;
/

select * from user_jobs;

Use dbms_job.remove to remove a job.
store procedure. [message #76604 is a reply to message #76484] Wed, 29 January 2003 22:53 Go to previous messageGo to next message
Daniel
Messages: 47
Registered: February 2000
Member
Prompts the user for a number. Use a loop to verifies user input.
Using the value x inputted, loop x times. Use x as the radius. Calculate the area of a circle with radius x.
Print the radius and area for each time through the second loop.

Turn in print out of code, and print screen with run of script
Re: Automatic execute a store procedure. [message #76923 is a reply to message #76484] Tue, 16 March 2004 09:49 Go to previous message
John Smith
Messages: 25
Registered: February 2002
Junior Member
If in unix use cron tables
Previous Topic: color change in from server
Next Topic: Pll problem in form 9i
Goto Forum:
  


Current Time: Thu Mar 28 13:24:14 CDT 2024