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;