cancel
Showing results for 
Search instead for 
Did you mean: 

scripts sap_new_dbcheck

Former Member
0 Kudos

Dear Expert

I have followed below note for the above problem Note 1637915 - DBCC Checkdb joblog  output contains warning message

e) Then cut and paste the scripts one by one in the query window and create the stored procedures in the SAP Database.

I have confusion to create the stored procedure please advise about that.

For SQL Server 2005, run the scripts sap_new_dbcheck.txt and  sap_add_dbccjob_s5.txt.

Regards

Accepted Solutions (0)

Answers (1)

Answers (1)

Reagan
Advisor
Advisor
0 Kudos

Hello

Open a query window and copy the contents from sap_add_dbccjob_s5.txt to the query window and execute it.

Then check whether the stored procedure is visible from the Databases - SID - Programmability - Stored Procedures

Regards

RB

Former Member
0 Kudos

Dear RB

Thanks for reply

I did same thing; its executed successfully then I go to SAP to check the stored procedure, the old procedure exist and did not replace by new one.

However, before I was able to schedule and run DBCC Check DB job in DB13 but now its giving error in SM21 during scheduling.

Database error 137 at OPC

> Must declare the scalar variable "@dbName".

Database error 137

Regards