修改schedule的start_date

Oracle version：Oracle Database 11g Enterprise Edition Release 11.2.0.3.0

SQL> desc dbms_scheduler.create_schedule
Parameter       Type                     Mode Default? 
--------------- ------------------------ ---- -------- 
SCHEDULE_NAME   VARCHAR2                 IN            
START_DATE      TIMESTAMP WITH TIME ZONE IN   Y        
REPEAT_INTERVAL VARCHAR2                 IN            
END_DATE        TIMESTAMP WITH TIME ZONE IN   Y        
COMMENTS        VARCHAR2                 IN   Y        


SQL> desc dbms_scheduler.set_attribute;
Parameter Type                           Mode Default? 
--------- ------------------------------ ---- -------- 
NAME      VARCHAR2                       IN            
ATTRIBUTE VARCHAR2                       IN            
VALUE     BOOLEAN                        IN            
NAME      VARCHAR2                       IN            
ATTRIBUTE VARCHAR2                       IN            
VALUE     VARCHAR2                       IN            
VALUE2    VARCHAR2                       IN   Y        
NAME      VARCHAR2                       IN            
ATTRIBUTE VARCHAR2                       IN            
VALUE     DATE                           IN            
NAME      VARCHAR2                       IN            
ATTRIBUTE VARCHAR2                       IN            
VALUE     TIMESTAMP                      IN            
NAME      VARCHAR2                       IN            
ATTRIBUTE VARCHAR2                       IN            
VALUE     TIMESTAMP WITH TIME ZONE       IN            
NAME      VARCHAR2                       IN            
ATTRIBUTE VARCHAR2                       IN            
VALUE     TIMESTAMP WITH LOCAL TIME ZONE IN            
NAME      VARCHAR2                       IN            
ATTRIBUTE VARCHAR2                       IN            
VALUE     INTERVAL DAY TO SECOND         IN  

SQL> desc dbms_scheduler.set_scheduler_attribute;
Parameter Type     Mode Default? 
--------- -------- ---- -------- 
ATTRIBUTE VARCHAR2 IN            
VALUE     VARCHAR2 IN   

set_attribute()：需要修改 PROGRAM、 JOB、 SCHEDULE  则用此过程，例如修改schedule的start_date，就只能用此过程，示例如下 ：

SQL> EXEC dbms_scheduler.set_attribute ('SEVEN_SCHEDULE','start_date',to_timestamp('20140629 14:25:00','yyyymmdd hh24:mi:ss'));

修改完schedule的start_date后，必须要重新激活使用此schedule的job，否则job不实际运行。

SQL> EXEC  DBMS_SCHEDULER.disable('JOB_DATATRACE');
SQL> EXEC  DBMS_SCHEDULER.enable('JOB_DATATRACE');


SET_SCHEDULER_ATTRIBUTE ：此过程能修改的属性，如下所列

Parameters

Table 129-97 SET_SCHEDULER_ATTRIBUTE Procedure Parameters

Parameter	Description
attribute	The name of the Scheduler attribute. Possible values are: 'default_timezone': Repeating jobs and windows that use the calendaring syntax retrieve the time zone from this attribute when start_date is not specified. See "Calendaring Syntax" for more information. 'email_server': The SMTP server address that the Scheduler uses to send e-mail notifications for job state events. E-mail notifications cannot be sent if this attribute is NULL. 'email_sender': The default e-mail address of the sender of job state e-mail notifications. 'email_server_credential': The schema and name of an existing credential object that SYS has execute object privileges on. Default is NULL. The username and password stored in this credential are used to authenticate with the e-mail server when sending e-mail notifications. This functionality is available with Oracle Database 11g Release 2 (11.2.0.2). 'email_server_encryption': This attribute indicates whether or not encryption is enabled for this email server connection, and if so, at what point encryption starts, and with which protocol. Values are: NONE: the default, indicating no encryption used SSL_TLS: indicating that either SSL or TLS are used, from the beginning of the connection STARTTLS:indicating that the connection starts unencrypted, but the command STARTTLS is sent to the e-mail server and starts encryption This functionality is available starting with Oracle Database 11g Release 2 (11.2.0.2). 'event_expiry_time': The time, in seconds, before a job state event generated by the Scheduler expires from the Scheduler event queue. If NULL, job state events expire after 24 hours. 'log_history': The number of days that log entries for both the job log and the window log are retained. Default is 30 and the range of valid values is 0 through 1000000. 'max_job_slave_processes': This Scheduler attribute is not used.
value	The new value of the attribute

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/27661381/viewspace-1199842/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/27661381/viewspace-1199842/