Job Triggers
The scheduled job can be activated by either of two types of triggers.
 | Trigger - an act that sets in motion some course of events. |
Simple Triggers
According to a single simple schedule trigger, action is executed predefined number of times with a fixed period. It is also possible specify start and end of time interval when the execution may take place. It is possible to define more then one trigger of this type. When execution is finished (this may happen because repeat count or end time is reached), the corresponding trigger is automatically removed from schedule. Properties of simple triggers are described here.
 | If a simple trigger was configured with a limited Repeat Count, the trigger record is automatically deleted from triggers table once all planned executions are complete. |
Advanced Triggers
Advanced schedule triggers allow complex execution patterns like "execute every minute starting at 2pm and ending at 2:59pm, every day" or "execute at 10:15am on every last Friday of every month during the years 2009, 2010, 2011 and 2012". There can be more than one such trigger. Triggers are automatically removed from the schedule when no executions should happen in the future, but in practice this happens only if the Year option is set to some finite range of years. Properties of advanced triggers are described here.
| Execution may not be scheduled for any combination of Day of Month and Day of Week at the same time. If execution pattern for any Day of Month is set to a non-Never value, patterns for every Day of Week must be set to Never and vice versa. |
Examples of Advanced Triggers
Day of Month | All days: Always (execute on every day of month) |
Month | All months: Enabled |
Day of Week | All days: Never (disabled, Day of Month is used in this pattern) |
Year |
|
Time | 09:00:00 |
Start Date/Time | <Not set> |
End Date/Time | <Not set> |
Execution Pattern | At 9:00am every day. |
Day of Month | All days: Always |
Month | All months: Enabled |
Day of Week | All days: Never |
Year | 2005 |
Time | 09:00:00 |
Start Date/Time | <Not set> |
End Date/Time | <Not set> |
Execution Pattern | At 9:00am every day during the year 2005. |
Day of Month | All days: Never |
Month | Mar: Enabled, others months: Disabled |
Day of Week | Wed: Always, other days: Never |
Year |
|
Time | 17:55:00 |
Start Date/Time | <Not set> |
End Date/Time | <Not set> |
Execution Pattern | At 5:55pm every Wednesday in the month of March. |
Day of Month | All days: Never |
Month | All months: Enabled |
Day of Week | Mon - Fri: Always, other days: Never |
Year |
|
Time | 05:15:00 |
Start Date/Time | <Not set> |
End Date/Time | <Not set> |
Execution Pattern | At 5:15am every Monday, Tuesday, Wednesday, Thursday and Friday. |
Day of Month | 15th: Always, other days: Never |
Month | All months: Enabled |
Day of Week | All days: Never |
Year |
|
Time | 09:00:00 |
Start Date/Time | <Not set> |
End Date/Time | <Not set> |
Execution Pattern | At 9:00am on the 15th day of every month. |
Day of Month | All days: Never |
Month | All months: Enabled |
Day of Week | Fri: Last, other days: Never |
Year |
|
Time | 09:00:00 |
Start Date/Time | <Not set> |
End Date/Time | <Not set> |
Execution Pattern | At 9:00am on the last Friday of every month. |
Day of Month | All days: Never |
Month | Jan - Mar: Enabled, other months: Disabled |
Day of Week | Fri: Last, other days: Never |
Year | 2006 - 2008 |
Time | 09:00:00 |
Start Date/Time | <Not set> |
End Date/Time | <Not set> |
Execution Pattern | At 9:00am on the last Friday of every January, February and March during years 2006, 2007 and 2008. |
Day of Month | All days: Always |
Month | All months: Enabled |
Day of Week | All days: Never |
Year |
|
Time | 09:00:00 |
Start Date/Time | 01.07.2007 00:00:00 |
End Date/Time | 01.08.2008 00:00:00 |
Execution Pattern | At 9:00am every day, first execution at 01.07.2007 09:00:00, last execution at 31.07.2007 09:00:00. |
Was this page helpful?