| DBMS_JOB [message #197616] |
Thu, 12 October 2006 01:29  |
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
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
