Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

DBMS_SCHEDULER job Last Start Date

2967512Nov 6 2015 — edited Nov 9 2015

I have a job scheduled to run every 15 minutes using DBMS_SCHEDULER

I used user_scheduler_jobs table to get last_start_date for my job and it reflects the time when the job last started.

But, when I manually run the job using DBMS_SCHEDULER.RUN_JOB('JOB_NAME'); the last_start_date still reflects the time when job was run automatically.

It does not reflect the time when I run the job manually.

I also observed that if the job was automatically run at 10 AM, the next_run_date in "user_scheduler_jobs" table shows 10:15AM even if I run the job manually at 10:10AM. (Shouldn't the next_run_date be 10:25AM?)

Is there any way I can access the time at which the job was run manually?

Thanks.

This post has been answered by Paulzip on Nov 6 2015

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Dec 5 2015

Added on Nov 6 2015

#database-key-features, #scheduler

9 comments

4,697 views