How to automate import operations, data purge or database compaction

Follow these steps to set up PROMODAG Reports to automatically update the directory, import data and perform additional tasks:

  1. Create a batch file and select what should be imported.
  2. Schedule the batch file using the Windows standard Task Scheduler.

A. Create the batch file

To create a batch file, select Tools > Task Automation to access the automation screen. 

Adding actions to the batch file: Import Message Tracking Data
  • Select Import Message Tracking Data in Available actions, then click .
  • Import message tracking files for the selected servers From last import To Yesterday.
  • In Import Directory Data, select Update from last import.
  • Click OK.

Adding actions to the batch file: Import IIS Data

  • Select Import IIS Data in Available actions, then click .
  • Import IIS log files for the selected servers From last import To Yesterday.
  • Click OK.
Adding actions to the batch file: Import Storage Size

Select Import Storage Size Data in Available actions, then click .

  • Select Mailbox size, Database size, Mailbox count per Information Store and Public Folders size depending on the Exchange databases your server hosts.
  • Click OK.

Adding actions to the batch file: Compact Database

  • Select Compact Database in Available actions, then click .

You can now name your batch file - for example, Daily Imports - and save it.

B. Schedule the batch file

You simply need to select the batch file you created at the previous step in the Task Automation windows, and click the Schedule button. You will then schedule the task in the Windows Task Scheduler.

Notes:

  • By default, actions will be carried out on the last database opened, unless you specify which database must be used (action: Database specification).
  • It is recommended to schedule it on a daily basis, and from 2 AM UTC onwards.

 See also:
How to automate report generation
Five Q & A about automating PROMODAG Reports
How to confirm that scheduled operations completed successfully
How to receive an email notification of warnings and errors when automating PROMODAG Reports
Troubleshooting automated mode and scheduled tasks issues

Add Feedback