UC4Blog

A technical UC4 Fan Blog

Dec. 22, 2011 at 07:49

End of the Calendar

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.

Automatic Notification

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:

  • With the validity term CALE_WARN_LEVEL you specify how many days before the expiry of a Calendar you want to be notified.
  • With the validity term CALE_WARN_CALL_OPERATOR (OM 6.00) / CALE_WARN_NOTIFICATION (OM 8.00, AE 9.00) you define the name of the Notification object the system executes to notify you.
    In the Notification object, you can read the name of the Calendar with
    :READ &UC_CAUSE_NAME,,

Example:

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: 

select

b.OH_CLIENT "Client",
b.OH_NAME "CALE",
a.OKB_NAME "Keyword",
a.OKB_VALIDTO "Expiration"

from

OKB a,
OH b

where

a.OKB_OH_IDNR = b.OH_IDNR
and b.OH_DELETEFLAG = 0
and b.OH_CLIENT != 0

order by

a.OKB_VALIDTO,Client,CALE,Keyword;

I wish you a Merry Christmas and a Happy New Year!

Categories:
  • Administration,
  • SQL
Last modified on 22. December 2011 at 07:54

No comments for this entry

Welcome to my blog!

 

Welcome to my UC4-Tech-Blog

Here you can find technical articles on UC4 Operations Manager

(versions 6.00 and 8.00) and the UC4 Auomation Engine (version 9.00).  I describe automation approaches, helpful SQL queries, and experiences with administration of a UC4 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 UC4 or the UC4 Software GmbH other than being a User of their software. The official, non-technical UC4-Blog can be found at http://www.uc4.com/blog

Name: Philipp Elmer

From: Austria

UC4-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 UC4, I already scheduled with cron ;-) , Maestro and Control-M.

Search