When running the job "CleanTempTable", the follow error is reported.
Execute as user Domain\Administrator. Could not locate entry in sysdatabases for database 'archivemanager'.
No entry found with that name . make sure the name is entered correctly . [SQLSTATE 08004] (error 911)
Edit the storeprocedure "UpdateCleanUpTime" in the ArchiveManager database.
Make sure it is referencing the correct database
Edit the Job "CleanTempTable".
Verify it is referencing the correct database
In steps, it should use the Command "Execute ArchiveManager.dbo.UpdateCleanUpTime"