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!

Column COMMENTS is NULL in USER_SCHEDULER_JOBS for LIGHTWEIGHT jobs

GregVDec 8 2017 — edited Jan 24 2018

Hi,

After creating some LIGHTWEIGHT jobs specifying a value for the COMMENTS argument of the DBMS_SCHEDULER.Create_Job procedure, I realised that the COMMENTS column was always NULL in the USER_SCHEDULER_JOBS view for such jobs. Looking at this view's underlying query, this is not surprising. The query uses a UNION ALL to get the ligthweight jobs from another sys table, and for the COMMENTS column a NULL is hard coded!

I can't access MOS KB at the moment, so I'm not sure if there's a MOS note about this. I can't find any indication in the documentation that says ligthweight jobs can't have comments. So it seems like a bug to me.

My version is 11.2.0.4. Do you know something about it?

Thanks

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 21 2018

Added on Dec 8 2017

#database-key-features, #scheduler

3 comments

430 views