Home » RDBMS Server » Performance Tuning » help in using DBMS_JOB
help in using DBMS_JOB [message #65200] Tue, 08 June 2004 04:56
fanni
Messages: 96
Registered: March 2004
Member
 

hi

i need to use dbms_job package. I have got and read its functions but still unable to know how to use these functions.

eg.

declare x number; begin

dbms_job.submit(x, 'proc1;', TRUNC(SYSDATE, 'DD'), 'TRUNC(SYSDATE+1,''DD'')');

commit;

end;

i need to know whether to use this code. whetherto use on any form button or at pl/sql editor.

Moreover whether this package will have to be created by mw or it is a built in .

farhan
Previous Topic: Understanding FIRST_ROWS
Next Topic: Performace Tuning Of Insert Statement
Goto Forum:
  


Current Time: Tue Feb 27 09:01:29 CST 2024