When a Stats Manager collect job runs, statistics are collected by TDStats.RunCollect XSP. If the TDStats database does not have permission to collect statistics as an object in the scope of a collect job, the statistics are not collected and an error is reported. Follow this step to prevent these errors.
-
To grant TDStats permission to collect statistics on any databases you associate with a collect job enter the following:
GRANT STATISTICS ON DATABASE TO TDStats;