Database Administration (MOSC)

MOSC Banner

Possible to change scheduler default job class?

edited Jul 17, 2020 5:03AM in Database Administration (MOSC) 2 commentsAnswered

Hi

Oracle 19.6

Linux

Is it possible to change default scheduler job class.

Whenever I create:

  • DOMAIN index
  • or create materialized view with refresh interval

Then, since I do not explicitly execute SYS.DBMS_SCHEDULER.CREATE_JOB, that oracle does itself, hence I cannot specify JOB CLASS.

At the moment default seems to be: DEFAULT_JOB_CLASS

I would like to change it to: DEFAULT_IN_MEMORY_JOB_CLASS in certain pdb-s, so it does not log all the RUNS (need FAILED_RUNS only)


Raul

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