This forum is currently locked. You can't register or post questions at this time. (read more)

Asynchronous way of calling procedures

All posts relating to Oracle PL/SQL development.

Moderator: Tim...

ponic
Senior Member
Posts: 160
Joined: Wed Mar 03, 2010 7:18 am

Re: Asynchronous way of calling procedures

Postby ponic » Fri Oct 05, 2012 3:42 pm

Tim

I am pretty sure I have used DBMS_SCHEDULER.create_job, I could see in DBA_SCHEDULER_JOB_RUN_DETAILS but not in dba_scheduler_programs.

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Asynchronous way of calling procedures

Postby Tim... » Sat Oct 06, 2012 7:51 am

Hi.

A program is only present if you have explicitly created it with CREATE_PROGRAM.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

ponic
Senior Member
Posts: 160
Joined: Wed Mar 03, 2010 7:18 am

Re: Asynchronous way of calling procedures

Postby ponic » Wed Oct 10, 2012 2:40 pm

So what exactly is the difference, create job and create program?

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Asynchronous way of calling procedures

Postby Tim... » Wed Oct 10, 2012 4:53 pm

Hi.

A program is the definition of a job action. You can define a program and have that same program called from multiple jobs.

A schedule is the definition of a specific schedule. A single schedule can be used by multiple jobs.

A job can use predefined programs and schedules, or define them in line are part of the job definition. You can see the basics of the scheduler here:

http://www.oracle-base.com/articles/10g ... er-10g.php

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog

ponic
Senior Member
Posts: 160
Joined: Wed Mar 03, 2010 7:18 am

Re: Asynchronous way of calling procedures

Postby ponic » Mon Oct 15, 2012 4:21 pm

Thanks a lot for the information, I am using CREATE_PROGRAM.

Regards

Tim...
Site Admin
Posts: 18437
Joined: Mon Nov 01, 2004 5:56 pm
Location: England, UK
Contact:

Re: Asynchronous way of calling procedures

Postby Tim... » Mon Oct 15, 2012 4:57 pm

OK. So once you've created your program(s), you will need to defines jobs that use them.

Cheers

Tim...
Tim...
Oracle ACE Director
Oracle ACE of the Year 2006 - Oracle Magazine Editors Choice Awards
OakTable Member
OCP DBA 7.3, 8, 8i, 9i, 10g, 11g
OCP Advanced PL/SQL Developer
Oracle Database: SQL Certified Expert
My website: http://www.oracle-base.com
My blog: http://www.oracle-base.com/blog


Return to “Oracle SQL and PL/SQL Development”

Who is online

Users browsing this forum: No registered users and 4 guests