cancel
Showing results for 
Search instead for 
Did you mean: 

MSSQL job SAP CCMS_prd_PRD_Update_Tabstats failed

Former Member
0 Kudos

Hello,

We are at SAP ERP ECC 5.0 (NW6.40) @ MSSQL2005 Server.

I have job on MSSQL Agent SAP CCMS_prd_PRD_Update_Tabstats which have step:

sap_update_tabstats 45

As I see this stored procedure doesn't exist? It is normal?

Regards,

Michal Sarna

Accepted Solutions (1)

Accepted Solutions (1)

JPReyes
Active Contributor
0 Kudos

As far as I know the job is created by default during installation.

Theres info about this job in SAP Note 1027512 - MSSQL: DBA cockpit for basis release 7.00 and later

Regards

Juan

Former Member
0 Kudos

So it looks like for 6.40 this job shouldn't be exist.

Is there any other job (in earlier versions that 7.0) which replace this functionality?

JPReyes
Active Contributor
0 Kudos

As it read in the notes reports RSMSSDBSZHIST and RSMSSDBSTATS should do the job

Regards

Juan

Answers (0)