The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides
Past Week stats rollupvc40 SQL Server job fails to complete after upgrading to vCenter (1014209)
vCenter 4.0 and vCenter 4.0 Update 1 use SQL Server Agent to run the following jobs to manage historical data:
- Past Day stats rollup
- Past Week stats rollup
- Past Month stats rollup
Download the file job_schedule2_mssql.sql attached to this KB article and perform the following steps:
- Connect to your vCenter database using the same login credentials used by vSphere, using the client utility for your database version (for example, the SQL Server Management Studio utiilty).
- Open a new query window and make sure that the vSphere database is selected.
- Paste the contents of job_schedule2_mssql.sqlin the new query window and click Execute.
The message Command(s) completed successfully is displayed when the SQL statements are executed.
Request a Product Feature
To request a new product feature or to provide feedback on a VMware product, please visit the Request a Product Feature page.