on 10-24-2013 12:50 PM
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
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
User | Count |
---|---|
87 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.