Home » SQL & PL/SQL » SQL & PL/SQL » Need to schedule more than one procedure in a single job (oracle 10g,windows xp sp3)
Need to schedule more than one procedure in a single job [message #414391] Tue, 21 July 2009 23:25 Go to next message
adusur
Messages: 36
Registered: June 2009
Location: Bhubaneswar
Member
Hi,
I am using the following script to create a job
which schedules a procedure.
BEGIN
Dbms_Scheduler.create_job(
job_name => 'DEMO_JOB_Custnode1'
,job_type => 'STORED_PROCEDURE'
,job_action => 'file_customernode1'
,start_date => SYSDATE
,repeat_interval => 'freq=hourly; byminute=0'
,enabled => TRUE
,comments => 'Demo for job schedule.');
END;


I would like to know that, is it possible to schedule morethan one procedure in a single job.
If possible please provide me the script to do that.

Thanks in advance,
Ravi.
Re: Need to schedule more than one procedure in a single job [message #414392 is a reply to message #414391] Tue, 21 July 2009 23:28 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>I would like to know that, is it possible to schedule morethan one procedure in a single job.
Create a single "wrappper" procedure that invokes multiple procedures sequentially.
Re: Need to schedule more than one procedure in a single job [message #414394 is a reply to message #414392] Tue, 21 July 2009 23:49 Go to previous messageGo to next message
adusur
Messages: 36
Registered: June 2009
Location: Bhubaneswar
Member
In this case each procedure need to process million records,
so if i call them from a procedure the last
procedure will be delayed.
So,all the procedures need to be executed simultaneously.
Re: Need to schedule more than one procedure in a single job [message #414395 is a reply to message #414391] Tue, 21 July 2009 23:52 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
>So,all the procedures need to be executed simultaneously.
Scope creep!

Proceed to do so.
It is your system to do as you command it.

Re: Need to schedule more than one procedure in a single job [message #414401 is a reply to message #414395] Wed, 22 July 2009 00:11 Go to previous messageGo to next message
adusur
Messages: 36
Registered: June 2009
Location: Bhubaneswar
Member
Can i specify two procedure names in the job_action field?
Re: Need to schedule more than one procedure in a single job [message #414439 is a reply to message #414391] Wed, 22 July 2009 03:19 Go to previous message
cookiemonster
Messages: 12415
Registered: September 2008
Location: Rainy Manchester
Senior Member
If you really need multiple procedures to be executed simultaneously you need to use multiple jobs.
Previous Topic: Help in Retrieving Oracle Keywords Defined Columns
Next Topic: How to schedule a jod to run at 10 AM, 3 PM everyday
Goto Forum:
  


Current Time: Wed Dec 07 10:39:31 CST 2016

Total time taken to generate the page: 0.11229 seconds