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.

Advertisements

2 Comments

  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

Leave a 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 )

Google+ photo

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

Twitter picture

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

Facebook photo

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

Connecting to %s