Database Administration (MOSC)

MOSC Banner

What calls/stores DBMS_JOB calls?

edited Sep 27, 2013 4:43AM in Database Administration (MOSC) 11 commentsAnswered
I have a DBMS_JOB submitted every hour (yes, part of the syntax of the call).  I'm looking to change the interval that it is called, but can't locate where that is done.

The call:

declare number;

begin

dbms_job.submit(j.'<PROCEDURE_NAME>;',sysdate,'sysdate + 1/24');

end;

/

What reads this every hour?  (I understand that "1/24" goes to "1" if I want it to run daily.  Just not sure where to set that (and how to keep this from running once an hour when I do).

Mike

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center