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

1 vote193 views1 answer
Mysql pretty date format
SQL
0 vote181 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
1 vote209 views3 answers
How to reset id column in sql server
SQL
1 vote173 views1 answer
Sql myisam vs innodb
SQL
0 vote196 views1 answer
Frename oracle
SQL
5 votes189 views1 answer
Sql use database
SQL
0 vote190 views1 answer
Sql menampilkan data tabel
SQL
0 vote207 views1 answer
Mysql exception output
SQL
0 vote184 views1 answer
Eliminar ultimo carcacter mysql
SQL
0 vote228 views1 answer
Cartesian product sql
SQL