To import the MWS_Standard_Cleanup
process, complete the following steps in Content Composer Studio.
-
On the Administration tab,
click the Repository Import
button.
- In the Specification of the import directory box, enter mws_cleanup.
-
On the Repository
Import tab, click the Execute
button.
- From the Navigator, open the MWS_Standard_Cleanup process.
- In the upper Editor pane, select the Timer object and if required, modify the properties in the Object Inspector.
- In the lower Editor pane, select the MwsAssistantManager component and then, in the Object Inspector, select the DB Alias that contains the connections details to the MWS database.
-
Optional.
Modify the Condition property.
The predefined value MWS_STATUS=2 deletes all MWS processes with the status Finished.
Example
To delete all processes that have been completed for at least 5 days, modify the condition as follows:
For SQL Server: MWS_STATUS = 2 and DATEDIFF(day, MWS_LASTSAVED, CURRENT_TIMESTAMP) < 6
For Oracle: MWS_STATUS = 2 and (SYSDATE-mws_lastsaved < 6)
-
Optional.
To change the number of days after MWS sessions are deleted by the MWS_Standard_Cleanup process,
complete the following substeps.
- In the upper Editor pane, select the MWS_Cleanup object.
- From the Object Inspector, open the MWS_Standard_Cleanup script.
-
In
the script. find the sessionAgeInDays variable
and change its value as needed.
Example
sessionAgeInDays = 20
- Save your changes.
-
On the Process
Designer Tools tab, under Create, click the Compile
button.
-
Configure
a Content Composer Windows service to host the MWS_Standard_Cleanup process.
For more information, see Hosting Processes