dbms_job transaction

[Valgar]

Hi, is it possible that

[TOracleSession].DBMS_Job.Submit(Id, Command, Now);

automatically starts a transaction and a commit is needed for it to start?

 

[Marco Kalter]

That is indeed correct. DBMS_JOBs are part of the Oracle transaction and must be committed or rolled back. See also the Oracle Database PL/SQL Packages and Types Reference.