This feature will be provided in version 4. Version 4 will support multiple calendars with inclusion and exclusion dates. : We have had some problems in scheduling processes where different divisions
: of the state have different holidays. Your software has only one holiday
: schedule. Below is a discription of our problem and a suggested solution
: outside of 24x7 but it would be nice if Softree could create a simular
: solution within the 24x7 application. Please look at the problem below and
: concider an update to your software. Because of the current limitation in
: your software we have been forced to consider other schedulers. I would
: not like to lose the great support that Softree has been providing just
: because of a small and simple function such as this.
: Bug #113 : Description : The Unisys scheduler has the ability to schedule around holidays and special
: days by accessing a calendar table that is maintained and updated by
: Production Control staff. This same table allows Production Control to
: schedule weekly and monthly processing on weekdays rather than weekends
: when holidays occur on Fridays or Thursday/Friday combinations. Normally
: month end processing takes place on the first Friday of the next month.
: When the first of the month is a Saturday processing takes place on the
: last day of the month. This becomes more complex when holidays are
: involved. Therefore manually updating a calendar table with processing
: dates is the only way to plan and schedule for some processing. We do not
: have that functionality with 24x7. The current setup on 24x7 includes
: dependencies that are passed on by the creation of semaphore files. This
: keeps the processes running in their proper order. To trigger the weekly
: processes a joining script developed by LAN Support tests for day of week
: each time the dailies are ran. If it is Friday a semaphore file is created
: to start the weekly processes. A similar joining script created by LAN
: Support is used to verify that it is the correct week to start the monthly
: processes. If it is the first Friday of the next month a semaphore file
: will be created to start the monthly processing. When holidays and when
: the 1st of the next month is a Saturday occur Production Control would
: have to manipulate the schedule on 24x7 by manual triggering, disabling
: and enabling jobs on the fly. This places a big responsibility and risk on
: the Production Control staff and potentially an impact to our users. : Proposed Solution : Create a table of process dates on SQL.
: Create an interface for Production Control to update the SQL table.
: Create a Visual Basic application that will read the SQL table and produce
: the appropriate semaphore files.
: Create a stored procedure for cleaning up old dates. : The 2 scripts that LAN Support created (weekly check and monthly check) would
: no longer be needed. The daily processing would then require the presence
: of a daily semaphore file in addition to the current setup. The weekly
: processes would then require the presence of a weekly semaphore file in
: addition to the current setup. The monthly would then require the presence
: of a monthly semaphore file in addition to the current setup. The Visual
: Basic application would be scheduled in 24x7 to run daily. Production
: Support would enter the processing dates as far in advance and desired.
: The stored procedure would be scheduled to run as needed for maintenance. : This solution could also be used for scheduling random processes in advance.
: Adding a division prefix to the semaphore file would allow for different
: schedules for different divisions. Adding a semaphore field to the table
: would allow entering a semaphore for specific processes. This adds
: unlimited possibilities.
|
