Asynchronous way of calling procedures

[ponic]

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...]

Hi.

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

Cheers

Tim...

[ponic]

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

[Tim...]

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...

[ponic]

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

Regards

[Tim...]

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

Cheers

Tim...