Print Thread
Schedule definition incomplete
#39376 01/27/11 09:45 PM
Joined: Mar 2000
Posts: 204
Akron, OH, USA
jlcox Offline OP
Member
OP Offline
Member
Joined: Mar 2000
Posts: 204
Akron, OH, USA
Consider:

Code
begin
  dbms_scheduler.create_schedule(schedule_name   => 'SCHD_2011_PLANT_HOLIDAYS',
                                 start_date      => to_timestamp_tz('01/01/2011 00:00:00 AMERICA/NEW_YORK',
                                                                    'dd/mm/yyyy hh24:mi:ss tzr'),
                                 end_date        => to_timestamp_tz('31/12/2011 23:59:59 AMERICA/NEW_YORK',
                                                                    'dd/mm/yyyy hh24:mi:ss tzr'),
                                 repeat_interval => 'freq=DAILY;bydate=20110422,20110530,20110704,20110705,20110905,
                                                     20111124,20111125,20111223,20111226,20111230',
                                 comments        => 'Plant Holidays 2011');
end;

Execute this in a command window, then query dba_scheduler_schedules and examine the REPEAT_INTERVAL column. Everything is good.

Now edit this schedule through the Scheduler window in PL/SQL Developer. Make a minor modification to the comments to enable the Apply button, then click it. Now query dba_scheduler_schedules again and look at the REPEAT_INTERVAL.

Uh-oh. A developer tool should not do damage like this.

Re: Schedule definition incomplete
jlcox #39386 01/28/11 10:27 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
That is indeed not correct. We'll fix it.


Marco Kalter
Allround Automations
Re: Schedule definition incomplete
Marco Kalter #54103 10/05/16 03:49 PM
Joined: Mar 2005
Posts: 7
Nebraska, USA
C
Member
Offline
Member
C
Joined: Mar 2005
Posts: 7
Nebraska, USA
[i]Did this get fixed? I noticed that when I update/change a job in version 11.0.6.1796 (64 bit) 12.94440 it is using the following code:

[i]begin
sys.dbms_scheduler.set_attribute_null(name => 'F1JOB_227009', attribute => 'repeat_interval');
sys.dbms_scheduler.set_attribute(name => 'F1JOB_227009', attribute => 'job_class', value => 'NEW_JOB_CLASS');
end;
/

Why would it be calling sys.dbms_scheduler.set_attribute_null? I did not change that value on the UI, just the Job Class.[/i][/i]

UPDATE: It appears that the UI does not poplulate the "Interval" field and it sees it as null when it goes to call the dbms_scheudler packages.

Last edited by Cecil Jones; 10/05/16 03:54 PM.
Re: Schedule definition incomplete
Cecil Jones #54107 10/06/16 09:50 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
We'll check it out.


Marco Kalter
Allround Automations
Re: Schedule definition incomplete
Marco Kalter #54607 11/28/16 10:03 PM
Joined: Mar 2005
Posts: 7
Nebraska, USA
C
Member
Offline
Member
C
Joined: Mar 2005
Posts: 7
Nebraska, USA
This still appears to be an issue in the latest beta release. This would be a great interface if it was fully functional. Right now it is makes a mess.

Last edited by Cecil Jones; 11/28/16 10:03 PM.
Re: Schedule definition incomplete
Cecil Jones #54619 11/29/16 09:30 AM
Joined: Aug 1999
Posts: 22,220
Member
Offline
Member
Joined: Aug 1999
Posts: 22,220
I will look into the status of this issue.


Marco Kalter
Allround Automations
Re: Schedule definition incomplete
Marco Kalter #54653 11/29/16 05:15 PM
Joined: Mar 2005
Posts: 7
Nebraska, USA
C
Member
Offline
Member
C
Joined: Mar 2005
Posts: 7
Nebraska, USA
More diagnostic information on this issue:

When I query dba_scheduler_jobs I have two entries listed below. You will notice that JOB_1 has a SCHEDULE_TYPE of PLSQL while JOB_2 has a SCHEDULE_TYPE of NAMED. I believe that the interface does not handle PLSQL schedule types correctly. Let me know if I can help in any other ways.

JOB_NAME JOB_1
JOB_STYLE REGULAR
PROGRAM_NAME RUN_JOB
SCHEDULE_NAME
SCHEDULE_TYPE PLSQL
REPEAT_INTERVAL sysdate + 60/86400

JOB_NAME JOB_2
JOB_STYLE REGULAR
PROGRAM_NAME RUN_JOB
SCHEDULE_NAME EVERY MINUTE
SCHEDULE_TYPE NAMED
REPEAT_INTERVAL

Last edited by Cecil Jones; 11/29/16 05:18 PM.

Moderated by  support 

Link Copied to Clipboard
Powered by UBB.threads™ PHP Forum Software 7.7.4
(Release build 20200307)
Responsive Width:

PHP: 7.1.33 Page Time: 0.038s Queries: 14 (0.016s) Memory: 2.5270 MB (Peak: 3.0427 MB) Data Comp: Off Server Time: 2024-05-18 08:32:27 UTC
Valid HTML 5 and Valid CSS