Method, system, and program for processing a job in an event driven workflow environment
First Claim
Patent Images
1. A method for processing a job, comprising;
- generating, with a computing system, a signal when status for the job is changed from a first status to a second status in a job status table, wherein each status for the job is associated with a single work process for processing the job among multiple work processes, wherein each status refers to a next process to be performed by the single work process associated with the status, wherein each work process is an application program, wherein the job status table identifies jobs on which work is performed, and wherein the signal is generated by an event trigger in a database at the computing system that is invoked in response to the change in status of the job in the job status table;
identifying using a mapping, with a user defined function, a single work process for processing the job based on the second status, wherein the second status is associated with the identified work process, wherein the user defined function is invoked by the event trigger with the second job status and wherein the mapping maps an input status of a job to a work process;
notifying, with the user defined function, the work process associated with the second status that one job had its status changed to the second status in response to the signal;
processing, with the work process, the job that had its status changed from the first status to the second status, wherein the work process queries the job status table to identify the job having the second status which is associated with that work process and to obtain job information in response to the notification; and
modifying, with the work process, the status of the job in the job status table after completing the processing of the job, wherein each work process is associated with one input status and one or more output statuses, wherein the modified status of the job is associated with another work process, wherein the mapping may be modified to perform at least one of adding, removing, and modifying statuses associated with work processes to modify an order of the job processing, and wherein the job is processed in a just-in-time manner.
5 Assignments
0 Petitions
Accused Products
Abstract
Disclosed is a method, system, and program for processing a job in a workflow environment. A signal is generated when status for the job is changed from a first status to a second status. A work process associated with the second status is notified that one job had its status changed to the second status in response to the signal. The work process processes the job that had its status changed from the first status to the second status and modifies the status of the job after completing the processing of the job.
-
Citations
36 Claims
-
1. A method for processing a job, comprising;
-
generating, with a computing system, a signal when status for the job is changed from a first status to a second status in a job status table, wherein each status for the job is associated with a single work process for processing the job among multiple work processes, wherein each status refers to a next process to be performed by the single work process associated with the status, wherein each work process is an application program, wherein the job status table identifies jobs on which work is performed, and wherein the signal is generated by an event trigger in a database at the computing system that is invoked in response to the change in status of the job in the job status table; identifying using a mapping, with a user defined function, a single work process for processing the job based on the second status, wherein the second status is associated with the identified work process, wherein the user defined function is invoked by the event trigger with the second job status and wherein the mapping maps an input status of a job to a work process; notifying, with the user defined function, the work process associated with the second status that one job had its status changed to the second status in response to the signal; processing, with the work process, the job that had its status changed from the first status to the second status, wherein the work process queries the job status table to identify the job having the second status which is associated with that work process and to obtain job information in response to the notification; and modifying, with the work process, the status of the job in the job status table after completing the processing of the job, wherein each work process is associated with one input status and one or more output statuses, wherein the modified status of the job is associated with another work process, wherein the mapping may be modified to perform at least one of adding, removing, and modifying statuses associated with work processes to modify an order of the job processing, and wherein the job is processed in a just-in-time manner. - View Dependent Claims (2, 3, 4, 5, 6, 8, 9, 10, 11, 12)
-
-
7. A method for processing a job, comprising;
-
generating a signal, with a computing system, when status for the job is changed from a first status to a second status in a database table, wherein each status for the job is associated with a single work process for processing the job among multiple work processes, wherein each status refers to a next process to be performed by the single work process associated with the status, wherein each work process is an application program, wherein the database table identifies jobs on which work is performed, and wherein the signal is generated by an event trigger in a database at the computing system that is invoked in response to the change in status of the job in the job status table; identifying using a mapping, with a user defined function, a single work process for processing the job based on the second status, wherein the second status is associated with the identified work process, wherein the user defined function is invoked by the event trigger with the second job status and wherein the mapping maps an input status of a job to a work process; notifying, with the user defined function, the work process associated with the second status that one job had its status changed to the second status in response to the signal in response to the notification; processing, with the work process, the job that had its status changed from the first status to the second status, wherein the work process queries the database table to identify the job having the second status which is associated with that work process and to obtain job information; modifying, with the work process, the status of the job in the database table after completing the processing of the job, wherein each work process is associated with one input status and one or more output statuses, wherein the modified status of the job is associated with another work process, wherein the mapping may be modified to perform at least one of adding, removing, and modifying statuses associated with work processes to modify an order of the job processing, and wherein the job is processed in a just-in-time manner; wherein job status is maintained in the database table including information on the job and maintaining, with the work process, a connection with the database that enables communication with the database table, wherein modifying the status of the job after completing processing comprises updating the status of the job to an output status associated with another work process, and wherein updating the status with the output status generates the signal indicating a change in status; wherein the work process further comprises performing; determining whether the work process completed processing the job successfully; and updating the status of the job to an error status if the work process did not complete processing the job successfully, wherein the status of the job is updated with one output status associated with the work process if the job work process completed processing the job successfully; and wherein an error work process is associated with the error status, wherein updating the job to the error status causes the notification of the error work process, and wherein the error work process further comprises performing; performing error recovery operations on the job; determining whether the error recovery operations corrected the job; and setting the jobs status of the corrected job to a first possible status in the workflow.
-
-
13. A system for processing a job, comprising;
-
means for generating, with a computing system, a signal when status for the job is changed from a first status to a second status in a job status table, wherein each status for the job is associated with a single work process for processing the job among multiple work processes, wherein each status refers to a next process to be performed by the single work process associated with the status, wherein each work process is an application program, wherein the job status table identifies jobs on which work is performed, and wherein the signal is generated by an event trigger in a database at the computing system that is invoked in resoonse to the change in status of the job in the job status table; means for identifying using a mapping, with a user defined function, a single work process for processing the job based on the second status, wherein the second status is associated with the identified work process, wherein the user defined function is invoked by the event trigger with the second job status and wherein the mapping maps an input status of a job to a work process; means for notifying, with the user defined function, the work process associated with the second status that one job had its status changed to the second status in response to the signal in response to the notification; means for processing, with the work process, the job that had its status changed from the first status to the second status, wherein the work process queries the job status table to identify the job having the second status which is associated with that work process and to obtain job information; and means for modifying, with the work process, the status of the job in the job status table after completing the processing of the job, wherein each work process Is associated with one input status and one or more output statuses, wherein the modified status of the job is associated with another work process, wherein the mapping may be modified to perform at least one of adding, removing, and modifying statuses associated with work processes to modify an order of the job processing, and wherein the job is processed in a just-in-time manner. - View Dependent Claims (14, 15, 16, 17, 18, 20, 21, 22, 23, 24)
-
-
19. A system for processing a job, comprising;
-
means for generating, with a computing system, a signal when status for the job is changed from a first status to a second status in a database table, wherein each stabs for the job is associated with a single work process for processing the job among multiple work processes, wherein each status refers to a next process to be performed by the single work process associated with the status, wherein each work process is an application program, wherein the database table identifies jobs on which work is performed, and wherein the signal is generated by an event trigger in a database at the computing system that is invoked in response to the change in status of the job in the job status table; means for identifying using a mapping, with a user defined function, a single work process for processing the job based on the second status, wherein the second status is associated with the identified work process, wherein the user defined function is invoked by the event trigger with the second job status and wherein the mapping maps an input status of a job to a work process; means for notifying, with the user defined function, the work process associated with the second status that one job had its status changed to the second status in response to the signal in response to the notification; means for processing, with the work process, the job that had its status changed from the first status to the second status, wherein the work process queries the database table to identify the job having the second status which is associated with that work process and to obtain job information; means for modifying, with the work process, the status of the job in the database table after completing the processing of the job, wherein each work process is associated with one input status and one or more output statuses, wherein the modified status of the job is associated with another work process, wherein the mapping may be modified to perform at least one of adding, removing, and modifying statuses associated with work processes to modify an order of the job processing, and wherein the job is processed in a just-in-time manner; wherein job status is maintained in the database table including information on the job, further comprising means for maintaining, with the work process, a connection with the database that enables communication with the database table, wherein the means for modifying the status of the job after completing processing comprises updating the status of the job to an output status associated with another work process, and wherein the means for updating the status with the output status generates the signal indicating a change in status; means for determining whether the work process completed processing the job successfully; means for updating the status of the job to an error status if the work process did not complete processing the job successfully, wherein the status of the job is updated with one output status associated with the work process if the job work process completed processing the job successfully; and wherein an error process is associated with the error status, wherein updating the job to the error status causes the notification of the error work process, further comprising; means for performing error recovery operations on the job; means for determining whether the error recovery operations corrected the job; and means for setting the jobs status of the corrected job to a first possible status in the workflow.
-
-
25. An article of manufacture for processing a job, the article of manufacture comprising computer usable media including at least one computer program and at least one work process embedded therein that causes at least one computer to perform:
-
generating a signal when status for the job is changed from a first status to a second status in a job status table, wherein each status for the job is associated with a single work process for processing the job among multiple work processes, wherein each status refers to a next process to be performed by the single work process associated with the status, wherein each work process is an application program, wherein the job status table identifies jobs on which work is performed, and wherein the signal is generated by an event trigger in a database at the computing system that is invoked in response to the change in status of the job in the job status table; identifying using a mapping a singe work process for processing the job based on the second status, wherein the second status is associated with the identified work process; notifying the work process associated with the second status that one job had its status changed to the second status in response to the signal in response to the notification; processing, with the work process, the job that had its status changed from the first status to the second status, wherein the work process queries the job status table to identify the job having the second status which is associated with that work process and to obtain job information; and modifying, with the work process, the status of the job in the job status table after completing the processing of the job, wherein each work process is associated with one input status and one or more output statuses, wherein the modified status of the job is associated with another work process, wherein the mapping may be modified to perform at least one of adding, removing, and modifying statuses associated with work processes to modify an order of the job processing, and wherein the job is processed in a just-in-time manner. - View Dependent Claims (26, 27, 28, 29, 30, 32, 33, 34, 35, 36)
-
-
31. An article of manufacture for processing a job, the article of manufacture comprising computer usable media including at least one computer program and at least one work process embedded therein that causes at least one computer to perform:
-
generating a signal when status for the job is changed from a first status to a second status in a database table, wherein each status for the job is associated with a single work process for processing the job among multiple work processes, wherein each status refers to a next process to be performed by the single work process associated with the status, wherein each work process is an application program, and wherein the database table identifies jobs on which work is performed, and wherein the signal is generated by an event trigger in a database at the computing system that is invoked in response to the change in status of the job in the job status table; identifying using a mapping a single work process for processing the job based on the second status, wherein the second status is associated with the identified work process; notifying the work process associated with the second status that one job had its status changed to the second status in response to the signal in response to the notification; processing, with the work process, the job that had its status changed from the first status to the second status, wherein the work process queries the database table to identify the job having the second status which is associated with that work process and to obtain job information; modifying, with the work process, the status of the job in the database table after completing the processing of the job, wherein each work process is associated with one input status and one or more output statuses, wherein the modified status of the job is associated with another work process, wherein the mapping may be modified to perform at least one of adding, removing, and modifying statuses associated with work processes to modify an order of the job processing, and wherein the job is processed in a just-in-time manner; wherein job status is maintained in the database table including information on the job, further comprising maintaining, with the work process, a connection with the database that enables communication with, the database table, wherein modifying the status of the job after completing processing comprises updating the status of the job to an output status associated with another work process, and wherein updating the status with the output stabs generates the signal indicating a change in status; wherein the work process further comprises performing; determining whether the work process completed processing the job successfully; and updating the status of the job to an error status if the work process did not complete processing the job successfully, wherein the status of the job is updated with one output status associated with the work process if the job work process completed processing the job successfully; and wherein one work process is an error work process is associated with the error status, wherein updating the job to the error status causes the notification of the error work process, wherein the error work process further comprises performing; performing error recovery operations on the job; determining whether the error recovery operations corrected the job; and setting the jobs status of the corrected job to a first possible status in the workflow.
-
Specification