Project

General

Profile

Actions
Copy link

Feature #99

closed

Daemon Program - Generate Daily Incomplete events list

Added by Chooi-Mey over 13 years ago. Updated over 13 years ago.

Status:
Closed
Priority:
Normal
Assignee:
chin-yeh
Start date:
04/18/2011
Due date:
% Done:

100%

Estimated time:
Resolution:
Fixed

Description

1) Run on 00:05 daily.
2) Retrieve records (all fields) from usa:event_log table, with criteria: status = INCOMPLETE; last_updated = <YESTERDAY>
3) Output: CSV file format; UTF-8.
4) Store into file system and also send file via email to notify.

Actions
Copy link
 #1

Updated by Chooi-Mey over 13 years ago

Changes:
1) Run on 01:05 daily.
2) Retrieve records (all fields) from usa:event_log table, with criteria: status = INCOMPLETE or PENDING; last_updated = <YESTERDAY>
3) Segegrate the files by status.
4) Files send within a email.

Actions
Copy link
 #2

Updated by chin-yeh over 13 years ago

  • Status changed from New to Feedback
  • % Done changed from 0 to 100
  • Resolution set to Fixed

already developed program. The program is developed based on this flow:

Activity Diagram - Event Report

To execute the program:
  1. cd to the directory:
     /usr/ecosway/daemon/qconnector
  2. then, execute the shell script:
    • Yesterday's events with INCOMPLETE status:
       ./event_report.sh INCOMPLETE
    • events with INCOMPLETE status on specific date:
       ./event_report.sh INCOMPLETE 2011-04-01
  3. the generated report will be saved in:
    /usr/ecosway/daemon/qconnector/reports
  4. (Optional) In order to receive the notification email, edit:
    vi /usr/ecosway/daemon/qconnector/config/EventReport.properties
    1. append the email address to the property name, app.email.recipient:
      e.g. app.email.recipient=cychoo@cosway.com.my;ecosway.nagios@gmail.com
  5. done.
Actions
Copy link
 #3

Updated by Chooi-Mey over 13 years ago

  • Status changed from Feedback to Closed

Tested.

Actions
Copy link

Also available in: Atom PDF