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

2 votes136 views1 answer
Wait delay in sql server
SQL
4 votes163 views3 answers
Is not null sql
SQL
0 vote111 views1 answer
Now() -1 mysql
SQL
4 votes141 views1 answer
Select nls_date_format
SQL
0 vote166 views1 answer
Format the money fied with comma in international system using sql
SQL
0 vote171 views1 answer
Show all sequences postgres
SQL
0 vote161 views1 answer
Psql generate id in existing database
SQL
50 votes222 views4 answers
Sql alter type of column
SQL
1 vote151 views1 answer
ERROR 1193 (HY000): Unknown system variable 'GTID_PURGED'
SQL
0 vote145 views1 answer
Get records in sql according to month name and count
SQL