|
-
Dbms_scheduler
i M NOT STUCK ON..
i DONT KNWO HOW TO RUN A PROCEDURE SUING SCHEDULER..IM TRYING TO CODE...
PLZ HAVE A LOOK OF IT...HERE IS IT....
begin
dbms_scheduler.create_job(
job_name => 'HIGHEST_HLC_UPDATE'
,job_type => 'STORED_PROCEDURE' --'PLSQL_BLOCK'
,job_action => 'BEGIN
MOVE_HLC_FOR_ACCOUNT();
END;' /*'begin package.procedure(''param_value''); end; '*/
,start_date => '01-APR-08 03.27.08.227555000 AM -07:00'
,repeat_interval => 'FREQ=DAILY'
,enabled => TRUE
,comments => 'HIGHEST HLC');
end;
REPEAT INTERVAL CAN BE ANYTHING FOR NOW...
BUT IS SYNTAX RITE FOR A PROCEDURE ..TO DECLARE IN THIS...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|