P6在SQL 2005 Express上无法运行数据库后台作业
1.SQL Server Express (2005) SCHEDULER: SQL 2005 Express 调度程序
Since Microsoft does not supply a process scheduler with SQL Server Express 2005, Primavera has created an agent that runs P6 background processes on SQLServer Express 2005. This Windows service, Primavera Background Agent(Service Name: Primavera Background Agent), is automatically installed when the standalone installation of P6 is used along with SQL Server Express 2005.
微 软在 SQL Server Express 2005 中未提供作业调度程序，因此 Primavera 创建了在 SQL Server Express 2005 上运行 Primavera 6.0 后台作业的代理服务。该 Windows 服务 Primavera Background Agent（服务名称：PrmBackAgent）在 Primavera 6.0 单机版与 SQL Server Express 2005 一同使用时自动安装。

Note: The Primavera Background Agent service is installed automatically by the P6 standalone installation and generally does not need to be manually installed
You may need to install the service if:
1. You have installed SQL Server Express (2005) after installing the standalone version of P6.
2. You have installed SQL Server Express (2005) on a server that doesn't have P6 installed on it.
注：PrmBackAgent 服务在需要时由 Primavera 6.0 安装程序自动安装，通常不需要手动安装或启动，除非是在安装 Primavera 6.0 单机版之后安装 SQL Server Express (2005)或者SQL 2005 Express的服务器上没有安装Primavera 6.0。

Manually Installing PrmBackAgent under SQL 2005 Express
在SQL 2005 Express上手动安装PrmBackAgent服务

Note: This is not required for full SQL 2000/2005 only SQL 2005 Express
注：在SQL 2000/2005上不需要手动安装PrmBackAgent服务

Althoughthe service is installed automatically by the P6 standaloneinstallation, the service can also be installed manually on the machinewhere the database is located. To install the service manually, youmust be a Windows user with admin access to the databases involved.Follow the procedure below to manually install the service.
1 Extract the prmbackgroundagent.exe executable from the Data1.cab file on CD 1.
2 Place the prmbackgroundagent.exe file in a directory on the local machine (for example, C:\Primavera\PrmBackAgent).
3 From the Start menu, click Run.
4 Substituting the appropriate path to the prmbackgroundagent.exe file from step 2, execute the following command to install the service:
C:\Primavera\PrmBackAgent\prmbackgroundagent.exe /install

虽然该服务是在需要时由 Primavera 安装程序自动安装，但也可手动安装。要手动安装该服务，必须是拥有所涉及数据库管理员权限的 Windows 用户。请按以下步骤来手动安装服务。
1 从 CD 1 上的 Data1.cab 文件中提取 prmbackgroundagent.exe 可执行文件。
2 将 prmbackgroundagent.exe 文件放置在本机的某个文件夹中（例如，C:\Primavera\PrmBackAgent）。
3 单击“启动”菜单中的“运行”。
4 替换步骤 2 中 prmbackgroundagent.exe 文件的相关路径，并执行命令以安装服务：
c:\primavera\PrmBackAgent\prmbackgroundagent.exe /install

Manually Registering and Starting PrmBackAgent under SQL 2005 Express
手动注册和启动 PrmBackAgent 服务

Before starting the service, the name of theserver instance containing the P6 databases must be added to theregistry. Follow the procedure below to manually add the serverinstance name to the registry.
在启动服务之前，必须将包含 Primavera 6.0 数据库的数据库实例名称添加到注册表中。请按照以下步骤来将数据库实例名称手动添加到注册表中。


1. Right-click on HKEY_LOCAL_MACHINE\Software\Primavera and choose "New", "Key".
在HKEY_LOCAL_MACHINE\Software\Primavera 中添加一个新注册表键


Enter the name "BackgroundAgent"
输入键值"BackgroundAgent"


2. Right-click on BackgroundAgent and choose "New", "String Value". Enter "Server".
右键点击BackgroundAgent，选择增加新字符串值，输入“Server”。





3. Right-click on Server and choose "Modify". Enter the SQL Server instance name in the "Value Data" field.
NOTE: for standalone installations localhost\primavera can be used.

右键点击Server，选择更改，输入SQL Server Express的名称。
注：该值与本地 SQL Server Express（例如，MyDesktop\sqlexpress）的实例名称相匹配。单机版本可以使用localhost\primavera。



4. When this is complete, reboot the machine.
完成后，重新启动计算机

Initializing Primavera Background Jobs
初始Primavera后台作业

Go to Start->Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express.
选择开始->程序->Microsoft SQL Server 2005->SQL Server Management Studio Express.
Click Connect to log in.
选择链接进行登陆


Click on "New Query"
点击“新查询”


Type: "use nameofdatabase
exec initialize_background_procs"
Where nameofdatabase is your Primavera Database name. The default is pmdb$primavera or PMDB.
Click the Execute button to run the query.
输入 "use nameofdatabase
exec initialize_background_procs" "use nameofdatabase
nameofdatabase为Primavera，默认名字为pmdb$primavera或者PMDB。
点击运行按钮执行查询。

If it was successful it will show "Command(s) completed successfully".
Close out of SQL 2005 Express.
成功运行后，显示"Command(s) completed successfully"。关闭SQL 2005 Express。

Open up Project Management. You may still see the error message. If so,.....
Let the program open fora couple of minutes to trigger the jobs to run. Symon process should run every 1 minute and Damon process every 5 minutes. Once both these jobs have ran successfully for the first time the users should not receive the error message while logging into Project Management.
打开PM，错误信息还是会出现，这时让程序继续运行来触发后台作业执行。Symon进程每一分钟运行一次，Damon进程每五分钟运行一次。当这两个进程完成第一次运行，登陆PM将不再出现错误信息。








2
prim66581:The database has not been configured run background jobs with SQL 2005 Express
prim66581: P6在SQL 2005 Express上没有配置运行数据库后台作业
Error: "The database has not been configured to run background jobs connecting to SQL 2005 Express"
Problem:
The database has not been configured to run background jobs.
How to check that background jobs are running correctly.
How to configure P6 to run background jobs.
When logging into Project Management 6.0 the following error is received: "The database has not been configured to run background jobs. Tocorrect this problem, please contact your System Administrator or seethe Primavera's Administrator Guide."
**Also included in the error are the last run times for each background job

SQL Server Express (2005) SCHEDULER: SQL 2005 Express 调度程序
Since Microsoft does not supply a process scheduler with SQL Server Express 2005, Primavera has created an agent that runs P6 background processes on SQLServer Express 2005. This Windows service, Primavera Background Agent(Service Name: Primavera Background Agent), is automatically installed when the standalone installation of P6 is used along with SQL Server Express 2005.
微软在 SQL Server Express 2005 中未提供作业调度程序，因此 Primavera 创建了在 SQL Server Express 2005 上运行 Primavera 6.0 后台作业的代理服务。该 Windows 服务 Primavera Background Agent（服务名称：PrmBackAgent）在 Primavera 6.0 单机版与 SQL Server Express 2005 一同使用时自动安装。
Note: The Primavera Background Agent service is installed automatically by the P6 standalone installation and generally does not need to be manually installed
You may need to install the service if:
1. You have installed SQL Server Express (2005) after installing the standalone version of P6.
2. You have installed SQL Server Express (2005) on a server that doesn't have P6 installed on it.
注：PrmBackAgent 服务在需要时由 Primavera 6.0 安装程序自动安装，通常不需要手动安装或启动，除非是在安装 Primavera 6.0 单机版之后安装 SQL Server Express (2005)或者SQL 2005 Express的服务器上没有安装Primavera 6.0。

Manually Installing PrmBackAgent under SQL 2005 Express
在SQL 2005 Express上手动安装PrmBackAgent服务
Note: This is not required for full SQL 2000/2005 only SQL 2005 Express
注：在SQL 2000/2005上不需要手动安装PrmBackAgent服务

Althoughthe service is installed automatically by the P6 standaloneinstallation, the service can also be installed manually on the machinewhere the database is located. To install the service manually, youmust be a Windows user with admin access to the databases involved.Follow the procedure below to manually install the service.
1 Extract the prmbackgroundagent.exe executable from the Data1.cab file on CD 1.
2 Place the prmbackgroundagent.exe file in a directory on the local machine (for example, C:\Primavera\PrmBackAgent).
3 From the Start menu, click Run.
4 Substituting the appropriate path to the prmbackgroundagent.exe file from step 2, execute the following command to install the service:
C:\Primavera\PrmBackAgent\prmbackgroundagent.exe /install
虽然该服务是在需要时由 Primavera 安装程序自动安装，但也可手动安装。要手动安装该服务，必须是拥有所涉及数据库管理员权限的 Windows 用户。请按以下步骤来手动安装服务。
1 从 CD 1 上的 Data1.cab 文件中提取 prmbackgroundagent.exe 可执行文件。
2 将 prmbackgroundagent.exe 文件放置在本机的某个文件夹中（例如，C:\Primavera\PrmBackAgent）。
3 单击“启动”菜单中的“运行”。
4 替换步骤 2 中 prmbackgroundagent.exe 文件的相关路径，并执行命令以安装服务：
c:\primavera\PrmBackAgent\prmbackgroundagent.exe /install
Manually Registering and Starting PrmBackAgent under SQL 2005 Express
手动注册和启动 PrmBackAgent 服务
Before starting the service, the name of theserver instance containing the P6 databases must be added to theregistry. Follow the procedure below to manually add the serverinstance name to the registry.
在启动服务之前，必须将包含 Primavera 6.0 数据库的数据库实例名称添加到注册表中。请按照以下步骤来将数据库实例名称手动添加到注册表中。
1. Right-click on HKEY_LOCAL_MACHINE\Software\Primavera and choose "New", "Key".
在HKEY_LOCAL_MACHINE\Software\Primavera 中添加一个新注册表键

Enter the name "BackgroundAgent"
输入键值"BackgroundAgent"
2. Right-click on BackgroundAgent and choose "New", "String Value". Enter "Server".
右键点击BackgroundAgent，选择增加新字符串值，输入“Server”。


3. Right-click on Server and choose "Modify". Enter the SQL Server instance name in the "Value Data" field.
NOTE: for standalone installations localhost\primavera can be used.
右键点击Server，选择更改，输入SQL Server Express的名称。
注：该值与本地 SQL Server Express（例如，MyDesktop\sqlexpress）的实例名称相匹配。单机版本可以使用localhost\primavera。

4. When this is complete, reboot the machine.
完成后，重新启动计算机
Initializing Primavera Background Jobs
初始Primavera后台作业
• Go to Start->Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express.
• 选择开始->程序->Microsoft SQL Server 2005->SQL Server Management Studio Express.
• Click Connect to log in.
• 选择链接进行登陆

• Click on "New Query"
• 点击“新查询”

• Type: "use nameofdatabase
exec initialize_background_procs"
Where nameofdatabase is your Primavera Database name. The default is pmdb$primavera or PMDB.
Click the Execute button to run the query.
• 输入
"use nameofdatabase
exec initialize_background_procs" "use nameofdatabase
nameofdatabase为Primavera，默认名字为pmdb$primavera或者PMDB。
点击运行按钮执行查询。

• If it was successful it will show "Command(s) completed successfully".
Close out of SQL 2005 Express.
• 成功运行后，显示"Command(s) completed successfully"。关闭SQL 2005 Express。

• Open up Project Management. You may still see the error message. If so,.....
Let the program open fora couple of minutes to trigger the jobs to run. Symon process should run every 1 minute and Damon process every 5 minutes. Once both these jobs have ran successfully for the first time the users should not receive the error message while logging into Project Management.
• 打开PM，错误信息还是会出现，这时让程序继续运行来触发后台作业执行。Symon进程每一分钟运行一次，Damon进程每五分钟运行一次。当这两个进程完成第一次运行，登陆PM将不再出现错误信息。