/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 vote175 views1 answer
Mysql jdbc timezone
SQL
1 vote179 views1 answer
Sql where last 12 months
SQL
5 votes175 views1 answer
How to check nls timestamp format in oracle
SQL
2 votes176 views1 answer
Oracle table size
SQL
0 vote172 views1 answer
Query on date sqlite flutter
SQL
0 vote180 views1 answer
Asp.net core sql server stored procedure
SQL
0 vote175 views1 answer
How to make case insensitive in sql
SQL
1 vote152 views1 answer
What are the cursors and what are the cursors types? in sql
SQL
1 vote195 views1 answer
Mysql get latest duplicate rows
SQL
0 vote173 views1 answer
Oracle index hint multiple tables example
SQL