MS SQL 2016 Server regular database maintenance task - description need

Installation Forum (Inactive)
MS SQL 2016 Server regular database maintenance task - description need jfvencl  2019-08-29 12:10
Status: Closed
 

We recently installed labkey on a linux RH7 server with a remote MS SQL Server 2016 database and during normal System Maintenance, the Database Maintenance task throws java.sql.SQLException: User does not have permission to perform this action. We would like to run the database maintenance task locally on the db server and would like to understand what tasks the Database maintenance is performing so we could duplicate that effort locally and disable the database maintenance task in System Maintenance schedule.

 
 
adam responded:  2019-08-29 15:44

In the case of SQL Server, the database maintenance task executes this simple SQL command:

EXEC sp_updatestats;

Adam

 
jfvencl responded:  2019-09-05 07:18

Thank you Adam, we are all set running this locally on our db server.