/SQL/Sql asynchronous stored procedure call

Sql asynchronous stored procedure call

-- 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 vote117 views1 answer
Mssql check if date is greater than today
SQL
1 vote106 views1 answer
Postgres killing connections on db
SQL
0 vote115 views1 answer
Migration graphql
SQL
4 votes101 views2 answers
Linq join
SQL
16 votes121 views2 answers
Sql vs nosql
SQL
4 votes130 views1 answer
Is there any command to change postgres password
SQL
0 vote121 views1 answer
Sql get table last modified time
SQL
0 vote107 views1 answer
Pl/sql loop example
SQL
2 votes108 views1 answer
How to search table name in stored procedure in sql server
SQL
1 vote75 views1 answer
What are the cursors and what are the cursors types? in sql
SQL