a technical Automic Fan Blog
The end of the year is approaching, and many offices are almost deserted in this supposedly contemplative time. Just at this time of the year, there are some special tasks, such as the annual financial statements and the holiday shopping season. If you are one of the chosen ones who must hold the fort, then this article should help save you from a small misfortune that might occur at the end of the year: The end of the calendar ... I mean a UC4 calendar, of course.
CALE validity period
Actually, Calendars don't end in UC4, but are valid some time back and forwards as defined by the keywords "NOW_MINUS" and "NOW_PLUS" in the UC4 variable UC_CLIENT_SETTINGS.
Only static Calendar Keywords and Keywords that depend on static ones have a fixed validity period and will expire if you don't adjust them in time.
Although one usually requires few or no static calendar definitions, most holiday Calendars in client 0 include at least one static entry, and if you haven't applied a hotfix for some time, your holiday Calendar might expire on 31.12.2011.
UC4 offers the possibility of automatic notification n days before a Calendar Keyword expires. The configuration of this feature is also in the UC4 variable UC_CLIENT_SETTINGS:
Check when Calendar Keywords expire
This little SQL provides a list of all calendar terms, sorted by expiration date, and is intended to avoid unpleasant End-Of-Year surprises:
a.OKB_OH_IDNR = b.OH_IDNR
and b.OH_DELETEFLAG = 0
and b.OH_CLIENT != 0
I wish you a Merry Christmas and a Happy New Year!
Welcome to my Automic-Tech-Blog
Here you can find technical articles on Automic Operations Manager (versions 6.00 and 8.00) and the Automic Auomation Engine (version 9.00). I describe automation approaches, helpful SQL queries, and experiences with administration of a Automic OM system and its components.
I hope you find interesting articles, and I'm looking forward to your comments.
One last small note:
I have no direct connection to Automic or the Automic Software GmbH other than being a User of their software.
Name: Philipp Elmer
Automic-User since: Summer 2006
I'm a freelancer and started in December 2000 as a Unix operator. My job always included some form of batch-processing, process-automation and scheduling.
Before working with Automic, I already scheduled with cron ;-) , Maestro and Control-M.