SQL agent jobs failed to run with warning in the application log.
SQL Server Scheduled Job Assign Security to New Messages - ArchiveManager (xxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxxx) - Status: Failed - Invoked on: yyyy-mm-dd hh:mm:ss - Message: The job failed. The Job was invoked by Schedule 2 (PopulateMailBoxMessage). The last step to run was step 1 (PopulateMailBoxMessage).
The job wasconfigured to run against a wrong database.
How to check which database it configured to run against.
1. Go to SQL server management studio
2. Expand SQL Server Agent - Jobs
3. Properties oneach Archive Manager job thenclickStepsand clickEdit
4. Under General page, make sure the database selected is your Archive Manager database.
Archive Manager jobs are as follow:
-Assign Security to All Messages - ArchiveManager
-Assign Security to New Messages - ArchiveManager
-Rebuild Index - ArchiveManager
