Jobs do not Run Automatically (Doc ID 205477.1)

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;

Cause