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

Report message to a moderator

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

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 03 14:18:34 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.