Oracle asynchronous procedure

-- 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 vote74 views2 answers
Jupyter notebook connect to database
SQL
5 votes115 views1 answer
Oracle find foreign key dependencies
SQL
0 vote122 views1 answer
Port 5432 is already in use Usually this means that there is already a PostgreSQL server running on your Mac. If you want to run multiple servers simultaneously, use different ports.
SQL
17 votes121 views3 answers
Postgresql version command
SQL
0 vote121 views1 answer
Postgres 11 add primary key
SQL
0 vote114 views1 answer
C# add a textbox in mysql select
SQL
1 vote125 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote108 views1 answer
Mysql repair a table
SQL
0 vote129 views1 answer
Sql max of two values
SQL
5 votes113 views2 answers
Mysqldump password
SQL