/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 vote186 views1 answer
Radius search with point data in mysql
SQL
0 vote144 views2 answers
How to find max and min salary in sql
SQL
0 vote124 views1 answer
Cannot truncate a table referenced in a foreign key constraint (`video_clips`.`channel_clips`, CONSTRAINT `clips_fk` FOREIGN KEY (`clip_id`) REFERENCES `video_clips`.`clips` (`id`)) in sql]
SQL
0 vote147 views1 answer
Install package for sqlserver in asp.net core
SQL
1 vote125 views1 answer
Woocommerce mysql price table
SQL
1 vote164 views1 answer
Drop colum oracle 18c
SQL
16 votes144 views6 answers
Insert sql
SQL
1 vote139 views1 answer
Sql week commencing date
SQL
2 votes141 views1 answer
Apex execute batch job
SQL
0 vote130 views1 answer
Make a socket server to detect changes in mysql
SQL