Often users will need to schedule the DDMDB scripts instead of running it manually every time when the DDMDB size increases to a large amount. This can be done using the post_olb_script or using the Windows scheduler.
In order to schedule the DDMDB maintenance and optimization scripts to have them run after a certain time period, we need to do some custom coding in the post_olb_script so that when the ddmdb is backed up after a SSDB backup, these scripts will run and optimize the ddm database. Attached is a sample post_olb script which runs the ddmdb scripts after every ddmdb backup. You can also use Windows scheduler to schedule the scripts. following is the process required:
Note: CA Support is not responsible for any customization done by the client. Also make sure you stop the Archive Manager when you schedule the DDMDB Maintenance script.