SQL Server Express (2005) SCHEDULER: SQL 2005 Express 调度程序
\A:m<:: 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.
t-dN:
1 微软在 SQL Server Express 2005 中未提供作业调度程序，因此 Primavera 创建了在 SQL Server Express 2005 上运行 Primavera 6.0 后台作业的代理服务。该 Windows 服务 Primavera Background Agent（服务名称：PrmBackAgent）在 Primavera 6.0 单机版与 SQL Server Express 2005 一同使用时自动安装。
/ fA:Fnv JO5~Vj_" Note: The Primavera Background Agent service is installed automatically by the P6 standalone installation and generally does not need to be manually installed
@z$V(}(O^ You may need to install the service if:
W
f 13Ab 1. You have installed SQL Server Express (2005) after installing the standalone version of P6.
s \#kqw\x 2. You have installed SQL Server Express (2005) on a server that doesn't have P6 installed on it.
(rt DT 注：PrmBackAgent 服务在需要时由 Primavera 6.0 安装程序自动安装，通常不需要手动安装或启动，除非是在安装 Primavera 6.0 单机版之后安装 SQL Server Express (2005)或者SQL 2005 Express的服务器上没有安装Primavera 6.0。
QV+('
w |>:mQnU Manually Installing PrmBackAgent under SQL 2005 Express
~ 6!=_" 在SQL 2005 Express上手动安装PrmBackAgent服务
9 NaC7D$, _.J{U0N Note: This is not required for full SQL 2000/2005 only SQL 2005 Express
")ow,r^" 注：在SQL 2000/2005上不需要手动安装PrmBackAgent服务
?ZdHuu DN~ f|?i6.N> f 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.
:
i3 -7 k 1 Extract the prmbackgroundagent.exe executable from the Data1.cab file on CD 1.
z
i2hi9A 2 Place the prmbackgroundagent.exe file in a directory on the local machine (for example, C:\Primavera\PrmBackAgent).
l+kI4B7-- 3 From the Start menu, click Run.
|GL#E"[&' 4 Substituting the appropriate path to the prmbackgroundagent.exe file from step 2, execute the following command to install the service:
5 LhFD C:\Primavera\PrmBackAgent\prmbackgroundagent.exe /install
V5 K`TC^
4&K~EX"^T 虽然该服务是在需要时由 Primavera 安装程序自动安装，但也可手动安装。要手动安装该服务，必须是拥有所涉及数据库管理员权限的 Windows 用户。请按以下步骤来手动安装服务。
y M , hF 1 从 CD 1 上的 Data1.cab 文件中提取 prmbackgroundagent.exe 可执行文件。
M^mS#<
!y 2 将 prmbackgroundagent.exe 文件放置在本机的某个文件夹中（例如，C:\Primavera\PrmBackAgent）。
vwZ2 kk!|i 3 单击“启动”菜单中的“运行”。
ff-9NvW4v 4 替换步骤 2 中 prmbackgroundagent.exe 文件的相关路径，并执行命令以安装服务：
>8 t3a-/ c:\primavera\PrmBackAgent\prmbackgroundagent.exe /install
zjM+F{P8 ff?:_q+.N Manually Registering and Starting PrmBackAgent under SQL 2005 Express
V Zb0x)w 手动注册和启动 PrmBackAgent 服务
Th`IpxV fseHuL=~ 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.
}c| Xr^ 在启动服务之前，必须将包含 Primavera 6.0 数据库的数据库实例名称添加到注册表中。请按照以下步骤来将数据库实例名称手动添加到注册表中。
`WC~cb \ DWHl,w;[z` &0K
H00l 1. Right-click on HKEY_LOCAL_MACHINE\Software\Primavera and choose "New", "Key".
tE9%;8;H 在HKEY_LOCAL_MACHINE\Software\Primavera 中添加一个新注册表键
H;G*tje/M [US.n +G 6
QlSZr[^ v Enter the name "BackgroundAgent"
K
S,X$)9 输入键值"BackgroundAgent"
-1:yqF. x ?#rDoYt/Sx oslrv7EK 2. Right-click on BackgroundAgent and choose "New", "String Value". Enter "Server".
?X]7jH<iw; 右键点击BackgroundAgent，选择增加新字符串值，输入“Server”。
4 rw<C07Z Tr(w~et X[(u]h` Qi w "x, SH<Nt[8C ^$6EO) < 3. Right-click on Server and choose "Modify". Enter the SQL Server instance name in the "Value Data" field.
kZ[E493bV NOTE: for standalone installations localhost\primavera can be used.
{&4+W=0
n &`Z>z T} 右键点击Server，选择更改，输入SQL Server Express的名称。
W.HM!HQp 注：该值与本地 SQL Server Express（例如，MyDesktop\sqlexpress）的实例名称相匹配。单机版本可以使用localhost\primavera。
R8W{[@ |*fGG?} rMH\;\
I|U vc^qp Ok 4. When this is complete, reboot the machine.
f}Mc2PQ- 完成后，重新启动计算机
}<[@)g.h. *=$Jv1"Q
+ Initializing Primavera Background Jobs
nkG1&wiX 初始Primavera后台作业
NJI-8qTGI GASDkVoij Go to Start->Programs->Microsoft SQL Server 2005->SQL Server Management Studio Express.
P@`@?kMU 选择开始->程序->Microsoft SQL Server 2005->SQL Server Management Studio Express.
w +fsw@dK& Click Connect to log in.
&j<B22t! 选择链接进行登陆
YiTiJ9jf U,gg@!1GJo QaH32( iH Click on "New Query"
0>
6J - 点击“新查询”
wI'T J e, \'x F\ V CCN rjaA Type: "use nameofdatabase
]o$aGrZ exec initialize_background_procs"
j2#RO>`,I Where nameofdatabase is your Primavera Database name. The default is pmdb$primavera or PMDB.
tda#9i[pkH Click the Execute button to run the query.
fa//~$#"{L 输入 "use nameofdatabase
9. 6"C<eYt exec initialize_background_procs" "use nameofdatabase
x"9`w 42\r nameofdatabase为Primavera，默认名字为pmdb$primavera或者PMDB。
<U%4$83$ 点击运行按钮执行查询。
?1T)cd* { 0RwjPYp If it was successful it will show "Command(s) completed successfully".
v*iD)k:|t Close out of SQL 2005 Express.
3q:U0&F 成功运行后，显示"Command(s) completed successfully"。关闭SQL 2005 Express。
R.@ I}> /'' |bIPa Open up Project Management. You may still see the error message. If so,.....
& Xm !i(i 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.
"m,)3zND3 打开PM，错误信息还是会出现，这时让程序继续运行来触发后台作业执行。Symon进程每一分钟运行一次，Damon进程每五分钟运行一次。当这两个进程完成第一次运行，登陆PM将不再出现错误信息。
[ 此帖被检查用户名在2009-02-05 15:57重新编辑 ]
