Update Stats Job

[Former Member]

Can someone tell me how to schedule an update statisitics job through db02? I want to run a job daily to update the stats on a specific table through db02.

Thanks,

Daniel

[Reagan]

Tx DB20 will let you create statistics for a specific table

Regards

RB

[Sriram2009]

Hi Daniel

In Which OS /DB Version ?

BR

SS

[Former Member]

SQLServer 2008 R2.

[Sriram2009]

Hi Daniel

Kindly refer the screen shot as per this have you enabled in MS SQL DB by using SQL Server Management Studio?

Since you are using MS Sql DB use the T-code ST04 to see the actions in DB02

Regards

Ram

[Former Member]

I want to run update stats from db02 on one table, via a scheduled job.

[Sriram2009]

Hi Daniel

Kindly refer the SAP Note

1353049 - SAP SQL Statistics has been removed from DBA Cockpit

You have to enable the DB statistics at database level that on MS SQL 2008 R2 Management studio Kindly refer the SCN link

http://scn.sap.com/thread/3495787

Regards

Sriram