Home » RDBMS Server » Server Administration » DBMS_JOB
DBMS_JOB [message #197616] Thu, 12 October 2006 01:29 Go to next message
thiyagaraj
Messages: 41
Registered: August 2006
Member
Hi

How can i include the minutes,seconds into this statement.
we have 6 schemas in our DB.Accordingly i have to write a DBMS_JOB script that runs three schemas in a day starts @ 23:30 in a 30minutes interval for each schema.
Here is the DBMS_JOB script(without minutes)::

DBMS_JOB.SUBMIT (:jobno,'stat;', sysdate,
'TRUNC(LEAST(NEXT_DAY(SYSDATE,''TUESDAY''),
NEXT_DAY(SYSDATE,''THURSDAY''),
NEXT_DAY(SYSDATE,''SATURDAY'') )) +23/24');

Note: 3 schemas has to run in the above mentioned script in 30 minutes interval.(having different jobno)

Thanks
Raaj
Re: DBMS_JOB [message #197712 is a reply to message #197616] Thu, 12 October 2006 07:01 Go to previous message
email.sandeepnaik
Messages: 121
Registered: August 2006
Senior Member
multiply hours * 60 to get min.So 23.30 job may look like 1410/1440

Sandeep
Previous Topic: Log Buffer Size
Next Topic: How to find out Biggest Schema in Database
Goto Forum:
  


Current Time: Sat Dec 03 01:23:07 CST 2016

Total time taken to generate the page: 0.12206 seconds