Home » Server Options » Text & interMedia » Re: DBMS_JOB
Re: DBMS_JOB [message #75960] Tue, 18 June 2002 22:10
Raja
Messages: 57
Registered: March 2000
Member
see
1 day = 24*60*60
1 hr = 60*60
1Mn = 1*60
15 Mn - 15*60

so for every 15 minutes

the code is

dbms_job.submit(myjob,delete_row;sydate,'sysdate + 15* 60/24*60*60')

ok

works perfectly...
Previous Topic: link error on ctxhx Ora 92010/RedHat7.3
Next Topic: Re: Help requested - context cartridge
Goto Forum:
  


Current Time: Fri Mar 29 09:05:11 CDT 2024