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 vote162 views1 answer
How to connect pgadmin with excel
SQL
16 votes173 views2 answers
Mysql date between two dates
SQL
2 votes191 views2 answers
How to add not null constraint in sql
SQL
1 vote351 views2 answers
Sql unique rows
SQL
0 vote167 views1 answer
Phpmyadmin tabellentyp ändern
SQL
0 vote175 views1 answer
One table with another
SQL
0 vote164 views1 answer
Alter table add column in SQL Server- NAYCode.com
SQL
2 votes129 views1 answer
Sql group by different columns
SQL
0 vote216 views1 answer
Copy row from db to db mysql
SQL
0 vote172 views1 answer
Mysql streaming example
SQL