We can see the picture given below to check what basically housekeeping job is:-
We use it to configure the message and log deletion to save database space in a productive environment. Attachment from the attachment basket has physically deleted when it was processed successfully. The attachment basket history contains only the header data of an attachment, which had processed successfully. When talking about attachment deletion then the entry of the history basket is deleted and not the physical attachment because it is already removed after successful processing.
As of release 2.x, the logs do the deletion of attachment history basket, messages, the global scheduler “DoMaintenance”.
Logs type:- #
Logs categorized into three levels as below:
- Error-Level log: used for logging exception occur, technical error or setup error like “No mappings error”…
- Warning-level log: this level for warning like (case workflows: No messages match to the condition of the workflow…)
- Info-level log: this level for information
Mostly you will see logs with the level error in the log screen.
Configuration of Message #
If your screen under the section “Message Setup” does not look like this screen you have to customize it.
Following is the description and explanation of the fields for the configuration.
Automatic Reprocessing #
You have to set this flag when you want that this integration should be taken into account by the scheduler “MessageReprocess”. For each integration, you have to decide to set or not set this flag. When this flag is set then the messages of this integration will be reprocessed. When this flag is not set then any reprocessing of messages from this integration will be done.
Delete Messages #
You have to set this flag when you want that this integration should be taken into account by the scheduler “DoMaintenance”. For each integration, you have to decide to set or not set this flag. When this flag is set then the messages of this integration will be deleted after the retention time. When this flag is set then no deletion of messages from this integration will be done. Note that setting this flag only tells the scheduler to consider this integration. By default, only messages with status “Completed” is deleted. If you want to delete other statuses then the status “Completed” then you have to add the additional statuses available under the section “Additional Message Statuses to Delete”.
Additional Message Statuses to Delete #
By default when the flag “Delete Messages” is set only messages with the status “Completed” is deleted. But sometimes you need also to delete messages with another status e.g. Cancelled. In this case, you have to add this status into the Box “Chosen” on the right side in the below screen.
In this screen, you can set the status of messages to be deleted additionally to the status “Completed”. In the box “Available” you have the statuses you can choose. Mark one entry and click on a button to add from the left to the right box. You can remove from the box “Chosen” by marking the entry in this box and click on the button.
Number of Days to Keep Messages #
In this field, you enter the number of days to keep messages in the database before they get deleted. If the value of this field is blank then the message will be deleted immediately regardless of when the message was created or modified. If the value is not blank for example 14 then messages will be kept 14 days in the database before they get deleted. The records’ Last Modified Date is relevant for the calculation – in other words, keep those records which was last modified within 14 days (counting from today).