Database Administration (MOSC)

MOSC Banner

Oracle 12c migration to 19c and jobs

in Database Administration (MOSC) 6 commentsAnswered

Hi,


When you update from 12c to 19c jobs are converted to scheduler jobs. So if you have a job 712 in 19c a dbms_job$_712 is created. So far so good. No problems with that.

But when I look at the 'last date' of the job and the 'last start date' of the sched. job it looks like the action defined in the job/sched.job is being executed twice. I can't imagine this is the case.

Any clarification/pointer to documentation about this?


And another question: what is best practice: drop the job (so only the sched.job is being executed)?

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

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center