While using P6, we may need to move SQL database to another computer. After backup and restore SQL database to another computer, every time we run P6, it might show this error : “The database has not been configured to run background jobs…”
I will show you how to fix it.
Go to Start menu -> SQL Server Configuration Manager.
Make sure SQL Server Agent is running.
Go to Start menu -> Login to SQL Server Management Studio.
Right click on the Primavera database, select New Query.
Enter following query:
Restart SQL Server Services.
Now when we run P6 the error will not appear.