URT shows Oracle queued job
Article ID: 272389
Updated On:
Products
Issue/Introduction
The enforce server console shows no jobs scheduled but the Oracle database continue to schedule jobs and show they are not ran.
Start: Oracle Queued Jobs - 2023-07-14 09:53:42
Job Description
-------------------- --------------------------------------------------
561 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
562 BEGIN DI_DataRefresh.PreProcessing; END;
563 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
564 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
570 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
566 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
567 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
568 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
569 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
565 BEGIN ID_IncidentDeletor.Main_Driver(p_Delete_Metho
.... .........
.... .........
There are 30 scheduled jobs that need to be unscheduled before the migrator
is run, please read instructions at the KB on how to unschedule these jobs.
Once the jobs are unscheduled, re-run the URT and continue your migration.
Start: Oracle System Parameter Validation - Date Time
Parameter Name Current Value Recommended Value
------------------------------ -------------------- --------------------
compatible 19.0.0 19.0.0.0.0
job_queue_processes 0 10
memory_target 0 3221225472
pga_aggregate_limit 2147483648 0
pga_aggregate_target 251658240 314572800
query_rewrite_enabled TRUE FALSE
session_max_open_files 10 20
sort_area_size 65536 0
Cause
The area highlighted in the Oracle System Parameter Validation indicates a job_queue_processes parameter needed for scheduled jobs has been disabled.
Resolution
Have the customer's DBA enable the process (and make it permanent).
Feedback
