Customers Temp Tables are not being purged.
Executed as user: DOMAIN\Services. Cannot drop the table E_5dc6e74e_b9e7_4394_bf2e_3c8bf40b13fa, because it does not exist in the system catalog. [SQLSTATE 42S02] (Error 3701). The step failed.
Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 8/6/2009
Time: 11:31:05 AM
User: N/A
Computer: SQLSTORE1
Description:
SQL Server Scheduled Job Clean Temp Tables AfterMail_Temp (0xBE85DE727CFB70449DAEF338DBB64B66) - Status: Failed - Invoked on: 2009-08-06 11:31:04 - Message: The job failed. The Job was invoked by User DOMAIN\adminuser. The last step to run was step 1 (Clean Temp Tables).
Local Admin Rights
Add ArchiveManagerServiceUsers security group to local Administrators Group on the SQL Server hosting the Archive Manager Databases.
