Primavera P6 SQL database error : “The database has not been configured to run background jobs…”

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.

Step 1:

Go to Start menu -> SQL Server Configuration Manager.

Make sure SQL Server Agent is running.

Primavera P6 SQL database error The database has not been configured to run background jobs-1

Step 2:

Go to Start menu -> Login to SQL Server Management Studio.

Right click on the Primavera database, select New Query.

Primavera P6 SQL database error The database has not been configured to run background jobs-2

Enter following query:

exec initialize_background_procs

Press F5

Primavera P6 SQL database error The database has not been configured to run background jobs-3

Step 3:

Restart SQL Server Services.

Now when we run P6 the error will not appear.

Advertisement

2 thoughts on “Primavera P6 SQL database error : “The database has not been configured to run background jobs…”

Add yours

  1. I would assume that what you mean to say in Step 1 is to “stop the SQL Server Agent” and not to “make sure that is is running” as you state in the article

    Like

    1. Hi there.
      Step 1 mean that you go to the function display in screenshot and check to make sure that the service is running. If it is currently stopped, make it run.

      Like

Leave a Reply to B'width Hog Cancel reply

Please log in using one of these methods to post your comment:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑