lundi 3 février 2020

Design Pattern and Database structure for developing a Status table

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