Hi All,
Long time reader first time poster.
Recently upgraded to MCMS SP2 from SP1a and changed back ed from SQL
2000 to 2005.
The SQL background processing job BGP-MCMS is now failing.
From Job History:
The job failed. The Job was invoked by User appdev. The last step to
run was step 2 (Purge content for deleted pages). The job was
requested to start at step 2 (Purge content for deleted pages).
The step that is failing is step 2 which I appears to be the execution
of an encrypted ms cms stored procedure bgp_DeleteDanglingPages
Error Message
"Unable to start execution of step 2 (reason: The job step contains
tokens. For SQL Server 2005 Service Pack 1 or later, you must use the
appropriate ESCAPE_xxx macro to update job steps containing tokens
before the job can run.). The step failed."
Maybe this will help:
The issue is described here for SQL Server 2005 and may present a
possible solution
http://sup****t.microsoft.com/kb/915845
Anybody come across this B4?
Is it a big problem if the job keeps failing?
Any help?
