Automated messaging tool
View Patent ↗A system and method for an automatic messaging system which automatically sends emails or pages to groups of people with specific data from a database. Other messaging tools may be utilized. The data source that provides information may be any ODBC compliant data source including standard DBMS (SQL Server, Oracle, Informix, DB2, Sybase, etc.) Access databases, or Excel spreadsheets.
1. A method comprising:
generating a first configuration file comprising a plurality of queries, each query associated with a connection string to connect to a respective database on a respective data source, a respective subject, and a respective list of recipients;
executing an application using information from the first configuration file to send a message to each respective list of recipients;
detecting an error in the first configuration file during execution of the application, the error comprising an incorrect query identified by the application;
generating a first error file in response to the detecting;
detecting abnormal termination of the application due to an error condition; and
appending information associated with the abnormal termination to the first error file in response to the detecting the abnormal termination of the application.
2. The method of claim 1 , wherein the first error file comprises a time the error was detected and a name for the first configuration file.
3. The method of claim 2 , wherein the error further comprises one of an incorrect user name, an incorrect password, and invalid file formatting.
4. The method of claim 1 , wherein each query comprises a set of instructions for selecting data from the respective database on the respective data source.
5. The method of claim 4 , further comprising:
scheduling a periodicity at which to send the message, the message including the selected data.
6. An apparatus comprising:
a processor; and
a memory to store computer program instructions, the computer program instructions when executed on the processor cause the processor to perform operations comprising:
generating a first configuration file comprising a plurality of queries, each query associated with a connection string to connect to a respective database on a respective data source, a respective subject, and a respective list of recipients;
executing an application using information from the first configuration file to send a message to each respective list of recipients;
detecting an error in the first configuration file during execution of the application, the error comprising an incorrect query identified by the application;
generating a first error file in response to the detecting;
detecting abnormal termination of the application due to an error condition; and
appending information associated with the abnormal termination to the first error file in response to the detecting the abnormal termination of the application.
7. The apparatus of claim 6 , wherein the first error file comprises a time the error was detected and a name for the first configuration file.
8. The apparatus of claim 7 , wherein the error further comprises one of an incorrect user name, an incorrect password, and invalid file formatting.
9. The apparatus of claim 6 , wherein each query comprises a set of instructions for selecting data from the respective database on the respective data source.
10. The apparatus of claim 9 , the operations further comprising:
scheduling a periodicity at which to send the message, the message including the selected data.
11. A computer-readable storage device storing computer program instructions, which, when executed on a processor, cause the processor to perform operations comprising:
generating a first configuration file comprising a plurality of queries, each query associated with a connection string to connect to a respective database on a respective data source, a respective subject, and a respective list of recipients;
executing an application using information from the first configuration file to send a message to each respective list of recipients;
detecting an error in the first configuration file during execution of the application, the error comprising an incorrect query identified by the application;
generating a first error file in response to the detecting;
detecting abnormal termination of the application due to an error condition; and
appending information associated with the abnormal termination to the first error file in response to the detecting the abnormal termination of the application.
12. The computer-readable storage device of claim 11 , wherein the first error file comprises a time the error was detected and a name for the first configuration file.
13. The computer-readable storage device of claim 12 , wherein the error further comprises one of an incorrect user name, an incorrect password, and invalid file formatting.
14. The computer-readable storage device of claim 11 , wherein each query comprises a set of instructions for selecting data from the respective database on the respective data source.
15. The computer-readable storage device of claim 14 , the operations further comprising:
scheduling a periodicity at which to send the message, the message including the selected data.