Requirements for Auto Notifier Project
● User should be able to configure settings such as email and sms gateway
● User should be able to configure job with time interval and define set of rules
○ Databases/Tables/columns should be displayed and based on the low/high values user should be able to define rule which triggers the SMS or Email notification.
○ Each column (integer, string) values where >, < , >=, <= and = conditions can define the rule.
○ Each rule set runs on one table. User should be able to configure such multiple rulesets.
○ SMS template/email template should be configurable at column level
● There can be multiple such jobs observing different tables and user should be able to configure it via simple user interface.
● Routine sms for status updation on daily basis with time interval or time settings
● Rule for checking data updation time and sending alert to only admin
● Sms should have present value.. Expected value
● Sms for unlimited numbers
● Email for unlimited numbers
● And sms and email should be qued so that if sometime Internet can disconnected. So it should send SMS when connectivity comes