Help - Search - Members - Calendar
Full Version: Scheduling a Job in the Stored Procedure
Oracle DBA Forums > Oracle > Oracle Forum
Phani Kumar
Hi all,

Need an urgent help on the following code.
PFB code i used to schedule a job as per my requirement.
And the procedure is executing fine, but when im about to run it is getting hang.

create or replace procedure scheduler_alert(frq varchar2,intrvl number) is
begin
dbms_scheduler.create_job(
job_name=>'scheduler_alert',
job_type=>'stored_procedure',
job_action=>'alertlog_error',
start_date=>SYSTIMESTAMP,
repeat_interval=>'FREQ='||frq||';INTERVAL='||intrvl,
enabled=>true,
auto_drop=>false);
end;
/


When im trying to run the job it is getting hang. unsure.gif

exec dbms_scheduler.run_job('scheduler_alert');

So please help me on this code ASAP.

Thanku


dave
why not just call dbms_scheduler.create_job directly
Phani Kumar
QUOTE (dave @ Dec 21 2011, 03:21 PM) *
why not just call dbms_scheduler.create_job directly


hi dave
thanks for responding...
actually im taking the input from the UI(asp.net) which have to store it in variable and pass as a parameter to the procedure as in the code.
if not this way to accomplish, pls suggest me on different way.
thanku...
burleson
Hi Phani,

>> Need an urgent help on the following code

What's urgent?

- How many people's lives are at risk?

- I an aircraftn about to crash?

ALL urgent matters are called to Oracleat 800-223-1711 not any forum . . . .

*****************************************
>> And the procedure is executing fine, but when im about to run it is getting hang.

LEASE READ:

http://www.dba-oracle.com/t_dbms_scheduler_examples.htm



This is a "lo-fi" version of our main content. To view the full version with more information, formatting and images, please click here.
Invision Power Board © 2001-2014 Invision Power Services, Inc.