Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » QAnywhere » QAnywhere reference » Server management request reference » Server management request parent tags

 

Schedule tag

You can optionally set up server management requests to run on a schedule. Use the following <schedule> subtags to define the schedule on which the request runs.

<schedule> subtags Description

<starttime>

Defines the time of day at which the server begins generating reports. For example:

<starttime>09:00:00</starttime>

<between>

Contains two subtags, starttime and endtime, which define an interval during which the server generates reports. May not be used in the same schedule as starttime. For example:

<between>
  <starttime>Mon Jan 16 09:00:00 EST 2006</starttime>
  <endtime>Mon Jan 17 09:00:00 EST 2006</endtime>
</between>

<everyhour>

Defines the interval between subsequent reports in hours. May not be used in the same schedule as everyminute or everysecond. For example, the following request generates a report every two hours starting at 9 AM:

<schedule>
  <starttime>09:00:00</starttime>
  <everyhour>2</everyhour>
</schedule>

<everyminute>

Defines the interval between subsequent reports in minutes. May not be used in the same schedule as everyhour or everysecond.

<schedule>
  <everyminute>10</everyminute>
</schedule>

<everysecond>

Defines the interval between subsequent reports in seconds. May not be used in the same schedule as everyhour or everyminute.

<schedule>
  <everysecond>45</everysecond>
</schedule>

<ondayofweek>

Each tag contains one day of the week in which the schedule is active. For example, the following schedule runs on Mondays and Tuesdays:

<schedule>
  <ondayofweek>Monday</ondayofweek>
  <ondayofweek>Tuesday</ondayofweek>
</schedule>

<ondayofmonth>

Each tag contains one day of the month on which the schedule is active. For example, the following schedule runs on the 15th of the month:

<schedule>
  <ondayofmonth>15</ondayofmonth>
</schedule>

<startdate>

The date on which the schedule becomes active. For example:

<startdate>Mon Jan 16 2006</startdate>

To modify a schedule, register a new server management request with the same requestId. To delete a schedule, register a server management request with the same requestId, but include the schedule tag <schedule>none</schedule>.

 Notes
 Example