troubleshooting Question

plsql job on oracle

Avatar of Jasmin shahrzad
Jasmin shahrzad asked on
Oracle DatabaseLinux
18 Comments1 Solution402 ViewsLast Modified:
i have a pl/sql scripts how to schedule it via oracle scheduler?
Just say the job name is ab.sql
looking for something like that:
BEGIN
DBMS_SCHEDULER.CREATE_PROGRAM (
   program_name           => 'check',
   program_action         => '/home/oracle/sql/ab.sql',
   program_type           => 'EXECUTABLE',
   repeat                        => everyday 01:00:00
   comments               => 'My comments here');
END;
/
ASKER CERTIFIED SOLUTION
Alex [***Alex140181***]
Software Developer

Our community of experts have been thoroughly vetted for their expertise and industry experience.

Join our community to see this answer!
Unlock 1 Answer and 18 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 18 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros