Have a Nice Morning,
Job Interval
I have a procedure "SMS_PRO" it send SMSs to me & to other Employees in my
company,
I want to put it in a Job but it should work every 5 Minits from 08:00 AM to
09:00 PM,
what should I use in the Interval to do so???
*
begin
*sys.dbms_job.submit(job => :job,
what => 'BEGIN
SMS_PRO;
END;',
next_date => to_date('21-06-2009 08:00:00', 'dd-mm-yyyy hh24:mi:ss'),
*interval* => ???????);
*commit*;
*end*;
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Oracle PL/SQL" group.
To post to this group, send email to Oracle-PLSQL@googlegroups.com
To unsubscribe from this group, send email to
oracle-plsql-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/Oracle-PLSQL?hl=en
-~----------~----~----~----~------~----~------~--~---
