simple update script

[Former Member]

Hi Expert

I want to write a simple execute script as below and run as a scheduler every week so can you tell me how can make a bat file and place in weekly scheduling

backup in windows 2003

Use <DBNAME>

EXEC sp_updatestats

go

regards

Piroz

[clas_hortien · Accepted solution]

Hi,

you can easily run such a short script via:

osql -S<SQL Server Instance> -E -Q"use <SID> exec sp_updatestats"

This line can be added to any Windows command script and will execute

sp_updatestats against the given database.

Why you don't use the SQL Agent for doing this ? He is designed for running scheduled task on he databases ?

Regards

Clas

[former_member193399 · Accepted solution]

Do you have any reason to update the statistics? SAP does not recommends to turn the "Auto Update statistics - On" and it is set to ON as part of the installation.

Thanks,

RT

[Former Member · Accepted solution]

Hi

Thanks very good and helpful solution

thanks