cancel
Showing results for 
Search instead for 
Did you mean: 

Database Update statistics Job in SQL server

Former Member
0 Kudos

Dear DB exeprts,

We are planing to schedule Database update statistics through a script or a sql job for a SQL server 2000 Database.

sap:4.7Enterpris edition

DB:SQL 2000

Requirements: Need to update statistics for all table

Time: Monthly once.

1. please advise how to schedule the Database update statistics job in SQL agent.

Thanks

Thiru.

Accepted Solutions (0)

Answers (4)

Answers (4)

Reagan
Advisor
Advisor
0 Kudos
former_member610738
Participant
0 Kudos

You can turn on automatic statistics update by running this SQL statement:

ALTER DATABASE YourDBName 
SET AUTO_UPDATE_STATISTICS ON

Follow this link -

http://www.mssqltips.com/sqlservertip/2766/sql-server-auto-update-and-auto-create-statistics-options...

former_member610738
Participant
0 Kudos

Hi Selven

Please follow this document http://msdn.microsoft.com/en-us/library/aa902688%28v=sql.80%29.aspx

and read this topic - "Maintaining statistics in SQL server 2000"

WR

Swati

Former Member
0 Kudos
Former Member
0 Kudos

Hi Vimal,

Thank you for your mail.

I have gone through the SAP NOTE#1558087 and 327494.

Notes provide detail info about above SQl2005 version.

I need to schedule the Database statistics in SQL 2000 agent.

Please let me know the steps for SQL2000 database.

Thanks

Former Member
0 Kudos

Hi,

Please open the below link  and page 150 , last line ...

http://www.sap-press.de/download/dateien/261/sap_press_database_005.pdf

This will give you a idea about your query.

http://scn.sap.com/thread/346640 will give you more info.

Please check and provide your feedback.

Thanks and Regards,

Vimal