Monitoring and raising alerts for database jobs
First Claim
1. An apparatus for monitoring a data process in a relational database management system, comprising:
- means for accepting a monitoring request for the data process, the monitoring request comprising an action time and an action information including an action code and an action destination;
memory for storing and retrieving the monitoring request in a row of a monitor request table stored in the relational database management system;
an alert control module for periodically processing the monitor request table to determine if an action characterized by the action code should be taken; and
means for comparing a current time to the action time;
means for initiating the action when the action time is earlier than the current time;
means for deleting monitoring requests for actions that have been taken; and
an alert action module for commanding the action specified by the action code when indicated by the alert control module.
2 Assignments
0 Petitions
Accused Products
Abstract
A method, apparatus, article of manufacture, and a memory structure for monitoring and raising alerts in data processing jobs. The alert and monitoring system uses a monitor request table stored in a relational database as a central repository in which data process jobs insert monitoring requests. The monitoring requests specify the time at which alerts or monitoring notices should be taken, and if the data processing job fails to submit an updated monitor request, the action described in the monitor request is taken. Provision is made for customized actions to be taken via a action alert table, which stores additional data allowing conditional and logical invocation of actions.
-
Citations
25 Claims
-
1. An apparatus for monitoring a data process in a relational database management system, comprising:
-
means for accepting a monitoring request for the data process, the monitoring request comprising an action time and an action information including an action code and an action destination;
memory for storing and retrieving the monitoring request in a row of a monitor request table stored in the relational database management system;
an alert control module for periodically processing the monitor request table to determine if an action characterized by the action code should be taken; and
means for comparing a current time to the action time;
means for initiating the action when the action time is earlier than the current time;
means for deleting monitoring requests for actions that have been taken; and
an alert action module for commanding the action specified by the action code when indicated by the alert control module. - View Dependent Claims (2, 3, 4, 5)
means for comparing a current time to the action time; and
means for initiating the action characterized by the action code when the current time is later than the action time.
-
-
3. The apparatus of claim 1, further comprising means for deleting monitoring requests for actions which have been taken.
-
4. The apparatus of claim 1, further comprising an alert action dynamic link library for reading an action definition from an alert action table stored in the relational database and for sending a command the perform the action.
-
5. The apparatus of claim 1 further comprising means for periodically accepting updated monitoring requests from the data process.
-
6. A method of monitoring a data process, comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request table data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed; and
(d) deleting the monitoring request from the monitor request data structure after the action has been taken; and
wherein the step of accepting a monitoring request in a monitor request data structure comprises the step of inserting the monitoring request as a row in a monitor request table. - View Dependent Claims (7, 8)
-
-
9. A method of monitoring a data process, comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request table data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed; and
(d) deleting the monitoring request from the monitor request data structure after the action has been taken; and
wherein the monitoring request is accepted from the data process.
-
-
10. A method of monitoring a data process, comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request table data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed;
(d) deleting the monitoring request from the monitor request data structure after the action has been taken;
(e) updating the monitoring request; and
(f) repeatedly performing steps (b) through (d) using the updated monitoring request.
-
-
11. A method of monitoring a data process, comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request table data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed; and
(d) deleting the monitoring request from the monitor request data structure after the action has been taken; and
wherein the step of taking an action characterized by the action code comprises the steps of;
reading an action definition from an action alert data structure; and
taking the action specified by the action definition.
-
-
12. A method of monitoring a data process, comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request table data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed; and
(d) deleting the monitoring request from the monitor request data structure after the action has been taken; and
wherein the step of taking the action characterized by the action code comprises the step of transmitting a message to an interested party.
-
-
13. An apparatus for monitoring a data process, comprising:
-
means for accepting a monitoring request associated with the data process in a monitor request data structure, the monitoring request having an action time and an action code;
means for recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
means for taking an action associated with the action code when the action time is earlier than the current time and the data process has not completed; and
deleting the monitoring request from the monitor request data structure after the action has been taken. - View Dependent Claims (14, 15, 16, 17, 18)
means for accepting an updated monitoring request from the data process and for recurrently processing the monitoring request table to determine if the action characterized by the action code should be taken.
-
-
18. The apparatus of claim 13, wherein the means for taking an action characterized by the action code comprises:
-
means for reading an action definition from an action alert data structure; and
means for taking the action specified by the action definition.
-
-
19. A program storage device, readable by computer having a processor and a memory, tangibly embodying one or more programs of instructions executable by the computer to perform the method steps of monitoring a data process, the method steps comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed; and
(d) deleting the monitoring request from the monitor request data structure after the action has been taken; and
wherein the method step of accepting a monitoring request in a monitor request data structure comprises the method step of inserting the monitoring request as a row in a monitor request table. - View Dependent Claims (20, 21)
-
-
22. A program storage device, readable by computer having a processor and a memory, tangibly embodying one or more programs of instructions executable by the computer to perform the method steps of monitoring a data process, the method steps comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed; and
(d) deleting the monitoring request from the monitor request data structure after the action has been taken; and
wherein the monitoring request is accepted from the data process.
-
-
23. A program storage device, readable by computer having a processor and a memory, tangibly embodying one or more programs of instructions executable by the computer to perform the method steps of monitoring a data process, the method steps comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed;
(d) deleting the monitoring request from the monitor request data structure after the action has been taken;
(e) updating the monitoring request; and
(f) repeatedly performing steps (b) through (d) using an the updated monitoring request.
-
-
24. A program storage device, readable by computer having a processor and a memory, tangibly embodying one or more programs of instructions executable by the computer to perform the method steps of monitoring a data process, the method steps comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed; and
(d) deleting the monitoring request from the monitor request data structure after the action has been taken; and
wherein the method step of taking an action characterized by the action code comprises the method steps of;
reading an action definition from an action alert data structure; and
taking the action specified by the action definition.
-
-
25. A program storage device, readable by computer having a processor and a memory, tangibly embodying one or more programs of instructions executable by the computer to perform the method steps of monitoring a data process, the method steps comprising the steps of:
-
(a) accepting a monitoring request associated with the data process in a monitor request data structure, the monitoring request having an action time and an action code;
(b) recurrently processing the monitoring request data structure to determine if the action time is earlier than the current time;
(c) taking an action characterized by the action code when the action time is earlier than the current time and the data process has not completed; and
(d) deleting the monitoring request from the monitor request data structure after the action has been taken; and
wherein the method step of taking the action characterized by the action code comprises the method step of transmitting a message to an interested party.
-
Specification