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
|
|
|