Hi all,
I have create 1 scheduler
begin
dbms_scheduler.create_job
(
job_name => 's1',
job_type => 'PLSQL_BLOCK',
job_action => '
Insert into for2 Select id,name,1 from for1;
Insert into for2 Select id,name,2 from for1;
Insert into for2 Select id,name,3 from for1;',
start_date => SYSTIMESTAMP,
repeat_interval => 'freq=secondly; interval=15',
enabled => TRUE,
comments => 'Streams heartbeat job from site A'
);
end;
Here i need 3 actions
Insert into for2 Select id,name,1 from for1;
Insert into for2 Select id,name,2 from for1;
Insert into for2 Select id,name,3 from for1;',
but i need
in this action i want to write 1 stored procedure with for loop Please any one help me
Thanks,
Malleswari.
|
| Author: Abhishek Arya 01 Sep 2008 | Member Level: Diamond | Rating:  Points: 2 |
this will help you out
http://www.aspfree.com/c/a/Database-Code/How-to-setup-a-stored-procedure-to-be-automatically-run/
http://msdn.microsoft.com/en-us/library/ms189880.aspx
|