Wednesday, December 6, 2017

DBMS_SCHEDULER.run_job in PLSQL



begin


DBMS_LOCK.SLEEP(1);

DBMS_SCHEDULER.run_job(job_name =>'"DBschemaname"."run_upload_batch_program"');

DBMS_LOCK.SLEEP(1);

end;
-

No comments:

Post a Comment

Subscribe to: Post Comments (Atom)

AWS how to delete VPC when it has error with Network interface , Gateway decencies

   how to delete VPC when it has error with Network interface , Gateway decencies  in AWS 1. Check if it is running on EC2 instance then Sto...