Oracle asynchronous update

-- To call a procedure asynchronously, create a auto_drop job:
BEGIN
    DBMS_SCHEDULER.create_job(
            job_name => 'My_JOB_NAME',
            job_type => 'PLSQL_BLOCK',
            job_action => 'BEGIN my_procedure(); END;',
            start_date => systimestamp,
            auto_drop => TRUE,
            enabled => TRUE
        );
END;

Similar codes

0 vote132 views1 answer
Code to move ietms from one table to another myswl
SQL
0 vote135 views1 answer
Guid string to binary better
SQL
-2 votes136 views1 answer
Modify column name in tsql
SQL
0 vote135 views1 answer
Grant access on table in oracle
SQL
0 vote132 views1 answer
Postgres sequence name
SQL
56 votes328 views5 answers
Psql create user
SQL
0 vote136 views2 answers
Postgres having
SQL
1 vote124 views3 answers
Rename table snowflake
SQL
1 vote130 views1 answer
Sql where max date
SQL
1 vote134 views1 answer
Return size of tables in mysql
SQL