Making using Java and Oracle as there are 5 scheduler jobs running daily
The status table could include following columns:
- Job Name (Name of Job/Unique ID or SHort Name)
- Start Date Time
- Status
- Finish Date Time
- Remarks
Business Logic:
• On Start of job, insert a row in status table with status as Start and datetime.
• On End of Job, Update the row with status as `success`
• On Exception, Update the row with status as `failed` with exception message.
* The next day next row will be created
Other applications need to pick records based on status table success.
Is there any issue in design or DB Structure or can it be handle in more elegant way and which design pattern should be used in this case?
Aucun commentaire:
Enregistrer un commentaire