Check Database Consisteny Job Fails

[Former Member]

I am trying to run the Check Database Consistency job on my database through DB13. But if fails each time with the following log:

• SQL Task information ************************

Jobname: SAP CCMS Check Database ERQ [20070717135631-7-210000]

Stepname: Step1

Type: TSQL

DB-Name: ERQ

Command: erq.sap_new_dbcheck @dbname="ERQ",@outputfile="$

(SQLDIR)\CCMS_CHECK_DB_HIST_2007.txt"

• Task history information *******************

For Run: 20070722 21:00:00

Status: (failure)

Duration: 0 hours(s) 0 min(s) 0 sec(s)

Last msg: Unable to start execution of step 1 (reason: The j

ob step contains one or more tokens. For SQL Serve

r 2005 Service Pack 1 or later, all job steps with

tokens must be updated with a macro before the jo

b can run.). The step failed.

• Task history information *******************

Any ideas on how to fix this? Running SQL Server 2005 Service Pack 1

[rolfc_weber · Accepted solution]

Hi,

Try look at sap note <a href="https://service.sap.com/sap/support/notes/947702">947702</a>

Regards

Rolf

[Former Member · Accepted solution]

Thanks. That looks like it will solve it.