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

5 votes137 views2 answers
Oracle timestamp to date
SQL
1 vote196 views1 answer
Postgres set sequence value to max id
SQL
0 vote141 views1 answer
Should I use the datetime or timestamp data type in MySQL?
SQL
0 vote150 views1 answer
Sql on-premises
SQL
2 votes159 views1 answer
Oracle apex who is connected
SQL
0 vote157 views1 answer
Replace divide by zero error with 0 in sql
SQL
0 vote144 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
0 vote149 views2 answers
Sql regex vowel
SQL
3 votes145 views2 answers
Monthname sql
SQL
0 vote149 views1 answer
Postgres: Create Column add constraint to the column with Query Output
SQL