Jobs do not Run Automatically
(Doc ID 205477.1)
Last updated on FEBRUARY 03, 2022
Applies to:PL/SQL - Version 188.8.131.52 and later
Information in this document applies to any platform.
Jobs submitted using the dbms_job package do not run automatically when you have a logon trigger which does a select from v$session. The snp process tries to run the job. But there are errors during the execution of the job and the job fails to execute. There are failures that are registered in the FAILURES column of user_jobs view.
The important thing to note is the statement:
SELECT program INTO prog FROM v$session WHERE audsid = sess;
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!