Problem

The default "Cleanup Tables" SQL job needs to be recreated e.g. for troubleshooting purposes; if has been dropped by mistake;  if it has been edited, etc. Email Firewall uses Microsoft SQL Server 2005.

Resolution

1. Download the attached script (cleanuptables.sql) with Microsoft SQL Server Management Studio client. Make sure to connect to the SQL server the EMF database resides on.

2. Edit the script as indicated in the comments /***** *****/ within the script. You will need to replace:

- SQLSERVER\Administrator with an appropriate administrative account.

- SQLSERVER with the SQL server hostname

- EMFMail with the database catalogue name for EMF should it differs from the default EMFMail

3. In Microsoft SQL Server Management Studio client first click Parse, to verify that the changes are applied correctly, then click Execute (F5)

The script will:

1. Drop the existing Cleanup Tables job

2. Create a new job with the same name and the default settings, it will also enable it and schedule it for daily execution at 1 AM.