Importing the MWS Cleanup Process - Advanced Design and Setup - Foundation 23.2 - Foundation 23.2 - Ready - Content Composer - external

Content Composer Advanced Design and Setup

Platform
Content Composer
Product
Advanced Design and Setup
Release
Foundation 23.2
License
To import the MWS_Standard_Cleanup process, complete the following steps in Content Composer Studio.
  1. On the Administration tab, click the Repository Import button.
  2. In the Specification of the import directory box, enter mws_cleanup.
  3. On the Repository Import  tab, click the Execute button.
  4. From the Navigator, open the MWS_Standard_Cleanup process.
  5. In the upper Editor pane, select the Timer object and if required, modify the properties in the Object Inspector.
  6. 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.
  7. 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)

  8. Optional. To change the number of days after MWS sessions are deleted by the MWS_Standard_Cleanup process, complete the following substeps.
    1. In the upper Editor pane, select the MWS_Cleanup object.
    2. From the Object Inspector, open the MWS_Standard_Cleanup script.
    3. In the script. find the sessionAgeInDays variable and change its value as needed.

      Example

      sessionAgeInDays = 20

  9. Save your changes.
  10. On the Process Designer Tools tab, under Create, click the Compile button.
  11. Configure a Content Composer Windows service to host the MWS_Standard_Cleanup process.
    For more information, see Hosting Processes