Configuring Alerts Service Jobs

Configuring Alerts Service Jobs #

The Analysis Server comes with an Alerts service handling the execution of scheduled jobs for sending email alerts and updating data for the Real-time dashboard. All the jobs included in the service are predefined, but all are configurable.

Job NameDescriptionCron ExpressionAlert Trigger Description
SyncLicenseStatuSynchronize license-status data from Core Server for Real-time dashboard.5 */5 * * * ?Triggers every 5minutes and 5 seconds
ArchiveDataMonitorMonitor Archive data loss based in archive file count.10 0 7 * * ?Triggers every 7:10 AM.
MaxUtilizationApplications that has reached certain percentage of utilization.10 */5 * * * ?Triggers every 5 minutes and 10 seconds.
LongCheckoutUsers that reached certain number of license checkout hours.10 0 * * * ?Triggers every top of the hour and 10 seconds.
SustainedMaxApplication running in maximum utilization for certain number of hours.10 0 * * * ?Triggers every top of the hour and 10 seconds.
LicenseExpirationFeatures which are about to expire in a certain number of days.10 0 7 * * ?Triggers every 7:10 AM.
LicenseHogsUsers with more than a certain number of concurrent licenses used10 */5 * * * ?Triggers every 5 minutes and 10 seconds.
LicenseDaemonDownDaemons which are on or have not communicated with Open iT server for the last certain number of minutes.10 */5 * * * ?Triggers every 5 minutes and 10 seconds.
LicenseServerDown SServers which have not communicated with Open iT server for the last certain number of minutes.10 */5 * * * ?Triggers every 5 minutes and 10 seconds.
LicenseStatusGet if the Open iT License is expiring in less than 30 days.0 0 7 * * ?Triggers every 7:00 AM.
RunEtlCheckerJobCheck the Analysis Server ETL background process if still running or has errors.0 0 12 * * ?Triggers every 12:00 PM.

To configure the jobs schedule and properties:

  1. Go to the configuration directory, C:¥Program Files¥OpeniT¥Analysis Server¥Configuration¥.
  2. Open the alertJobs.config file.
    The file contains all the scheduled jobs and triggers information.

Use the information provided in the section Alerts Configuration File to properly configure the Alerts Service.

  1. Save the changes
  2. Restart the Open iT Alert Service by following these instructions:
    1. Open the command prompt as an Administrator.
    2. Run this command to stop the Open iT Alerts service:
      > net stop openitalerts
      Allow the process to finish.
    3. Run this command to start the Open iT Alert service:
      > net start openitalerts
      Allow the process to finish.

Alert Job Configuration File #

Use this information to manually modify the alertJobs.config configuration file.

nameStringName of the job scheduled job
groupString (Job or Alerts) Job is for scheduled jobs that only execute a specific task or command. Alerts is for scheduled jobs that use the email alert functionality and send email notification.Group assigned to the scheduled job.
descriptioStringDescriptive information of the scheduled job.
job-typeStringTask or class executed by the job.
durableBooleanLife span of a job. Non-durable jobs have a life span bounded by the existence of its triggers.
recoverBooleanBehavior of the job after the process or machine in which it is running either shuts down or crashes.
job-data-mapkey is the string name that identifies the entry value is the value used as argumentKeys used as arguments in executing a job.

nameStringName of the scheduled cron.
groupString (JobTriggers or AlertTriggers)

JobTriggers is for crons that only execute a specific task or command. AlertTriggers is for crons that use the email alert functionality and sends email notification.
Group assigned to the scheduled cron.
descriptionStringDescriptive information of the scheduled cron.
job-nameStringName of the job executed by the trigger. This should be the same with the corresponding job name.
job-groupStringGroup of the job to be triggered.
misfire-instructionsStringA policy used when a persistent trigger misses its execution time because the scheduler shut down or there are no available threads. This is by default SmartPolicy.
cron-expressioncron expressionA cron expression is a string comprised of 6 or 7 fields separated by white space(s). The fields can contain any of the values allowed, along with various combination of the special characters allowed for that field.

Cron Expression Format #

Use this information to properly configure the cron-expression attribute of the configuration file.

Field NameMandatoryAllowed ValuesAllowed Special Characters
SecondsYES0 - 59, - * /
MinutesYES0 - 59, - * /
HoursYES0 - 23, - * /
Day of MonthYES0 - 31, - * ? / L W
MonthYES1 - 12 or JAN - DEC, - * /
Day of WeekYES1 - 7 or SUN - SAT, - * ? / L #
YearNOempty or 1970 - 2099, - * /

Note: Cron expression can be as simple as * * * * ? *

Special Characters #

Use this information to provide a valid cron expression.

Special CharacterDescription
* ("all values")Used to select all values within a field. For example, an asterisk (*) in the minute field means "every minute."
? ("no specific value")Used to input no specific value in a field. This is used when it is needed to specify something in one of the two fields in which the character is allowed, but not the other.
- ("dash")Used to specify ranges.
, ("comma")Used to specify additional values.
/ ("slash")Used to specify increments. The first number is where the counting starts and the second number is the interval. For example, 0/15 in the seconds field means the seconds 0. 15. 30 and 45.
L ("last")seconds 0. 15. 30 and 45.

L ("last") This has a different meaning in each of the two fields where it is allowed. When used in the day-of-month field, it means "the last day of the month." When used in the day-of-week field by itself, it simply means "7" or "SAT." But if used in the day-of-week field after another value, it means "the last specified day of the month" - for example, "6L" means "the last Friday of the month." It's allowed to specify an offset from the last day of the month, such as "L-3," which would mean "the third to last day of the calendar month."
W ("weekday")Used to specify the weekday (Monday-Friday) nearest to the specified day. For example, "15W" specified in the day-of-month field means "the nearest weekday to the 15th of the month." So, if the 15th is a Sunday, the trigger will fire on Friday the 14th.
# ("hash tag")Used to specify "the nth day of the month".. For example, the value of "6#3" in the day-of-week field means "the third Friday of the month."

Warning: When using the “L” option, it is important not to specify lists or ranges or values to avoid confusing or unexpected results.

Note: The “L” and “W” characters can also be combined in the day-of-month field to yield “LW” which translates to “last weekday of the month”.
The legal characters and the names of the months and days of the week are not case sensitive. MON is the same as mon.

Cron Expression Examples #

Use this information as a guide in providing cron expressions.

0 0 12 * * ?Fire at 12pm (noon) every day
0 15 10 ? * *Fire at 10:15am every day
0 15 10 * * ? 2005Fire at 10:15am every day during the year 2005
0 0/5 14 * * ?Fire every 5 minutes starting at 2pm and ending at 2:55pm, every day
0 10,44 14 ? 3 WEDFire at 2:10pm and at 2:44pm every Wednesday in the month of March
0 15 10 ? * 6LFire at 10:15am on the last Friday of every month
0 15 10 ? * 6#3Fire at 10:15am on the third Friday of every month