Home » SQL & PL/SQL » SQL & PL/SQL » DBMS_JOB (9i,9.2.0.6,Winxp)
DBMS_JOB [message #344527] Sat, 30 August 2008 03:47 Go to next message
alok416
Messages: 7
Registered: June 2005
Location: India
Junior Member



Hi All,

I need to run the staspack report that should meet the following condition.

every 15 minutes on the 15 minutes except during our batch window of midnight until 7am, during which time we would like performance snapshots taken every 2 hours at the top of the hour (midnight, 2, 4 and 6).

As far as every 15 min, I have not problem with this, but how come I specify the time , that should meet the above condition.

hare krishna
Alok
Re: DBMS_JOB [message #344533 is a reply to message #344527] Sat, 30 August 2008 04:52 Go to previous messageGo to next message
ThomasG
Messages: 3189
Registered: April 2005
Location: Heilbronn, Germany
Senior Member
It might be easier to have a procedure that is just started every 15 minutes via DMBS_JOB.

Then INSIDE the procedure either start the report, or don't start it depending on what the time is.

E.g. when it's between 00:00 and 07:00 only start it when the hour can be divided by two.
Re: DBMS_JOB [message #344544 is a reply to message #344527] Sat, 30 August 2008 07:14 Go to previous messageGo to next message
Frank
Messages: 7880
Registered: March 2000
Senior Member
Create a function that calculates the new running time based on the current time. Use the outcome of that for the interval (hm, or am I mixing up dbms_job and dbms_scheduler now...)
Re: DBMS_JOB [message #344555 is a reply to message #344527] Sat, 30 August 2008 09:49 Go to previous message
Michel Cadot
Messages: 64119
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Here's an example:
http://www.orafaq.com/forum/m/313430/102589/?msg_313430#msg_313430

Regards
Michel
Previous Topic: SQL and PL\SQL
Next Topic: How to improve select coun(*) from table
Goto Forum:
  


Current Time: Tue Dec 06 08:32:06 CST 2016

Total time taken to generate the page: 0.13350 seconds