/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 vote159 views1 answer
Get cpu details sql
SQL
0 vote142 views1 answer
Get who is hired in specific month in sql
SQL
0 vote147 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
11 votes153 views6 answers
Mysql else if
SQL
0 vote179 views1 answer
MySQL - How to find word with the most similar beginning
SQL
0 vote149 views1 answer
How to insert a uniqueidentifier in sql
SQL
0 vote149 views4 answers
Database stuck at restoring state
SQL
4 votes142 views1 answer
Sql group by year
SQL
0 vote159 views8 answers
Convert sql query to linq online
SQL
4 votes157 views3 answers
Employee name starting with in sql
SQL