My Oracle Support Banner

Jobs do not Run Automatically (Doc ID 205477.1)

Last updated on FEBRUARY 03, 2022

Applies to:

PL/SQL - Version and later
Information in this document applies to any platform.Symptoms

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!

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.