Bug in dbms_job edit?

[rthibault]

I've noticed that when I edit jobs, the next date will often set itself to 1/1/4000. I'm running 6.0.1 against Oracle 8.1.3.

 

[Marco Kalter]

I can't reproduce this. If possible, can you send me the exact steps to reproduce this? Can you also confirm your Oracle Server version? I assume 8.1.3 is a typo.

 

[rthibault]

Yes, sorry, that should have been 8.1.7.3.

It seems to happen whenever I manually mark a job as Broken.

1. Open list of Jobs in left-hand browser pane.
2. Right-click job and select Edit.
3. Check Broken checkbox.
4. Next Date value changes to 1/1/4000.

 

[Marco Kalter]

You're right, setting broken will indeed set the next date to 1/1/4000. This is the implicit result of calling:

dbms_job.broken(job => 123, broken => true);