Automated messaging tool
First Claim
Patent Images
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.
9 Assignments
0 Petitions
Accused Products
Abstract
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.
-
Citations
15 Claims
-
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. - View Dependent Claims (2, 3, 4, 5)
-
-
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. - View Dependent Claims (7, 8, 9, 10)
-
-
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. - View Dependent Claims (12, 13, 14, 15)
-
Specification