Performance data is currently not available in vcenter 5.0. So I verified the existence of jobs and removed them:
Open SQL Management Studio using a Sysadmin account (typically SA or Administrator). Expand the Server and SQL Server Agent.
Note: Ensure the SQL Server Agent is running. If it is not running, right-click the SQL Server Agent and select Start. Determine if the issue is still occurring.
Click the Jobs folder. You see a list of all jobs available on your server.
These jobs are related to vCenter Server 5.0:
- Past Day Stats Rollup
- Past Week Stats Rollup
- Past Month Stats Rollup
Right-click any of these jobs, if they exist, and select Delete.
- Click OK to confirm the deletion.
- Close SQL Management Studio when these jobs are removed.
Adding the SQL Server Agent Jobs
To add a SQL Server Agent job:
- Click File > Open > File.
open : C:\Program Files\VMware\Infrastructure\VirtualCenter Server\
Open job_schedule1_mssql.sql. ( Ensure that the VirtualCenter Database (for example, VCDB) is selected and that Master is not selected.)
Right-click the VirtualCenter Database and select New Query.
- Copy the query outlined in job_schedule1_mssql.sql to the New Query pane in SQL Management studio, then click Execute Query.
Repeat steps 1 to 3 for job_schedule2_mssql.sql and job_schedule3_mssql.sql.
Right-click the Jobs folder and click Refresh.
After all three jobs are created, navigate to SQL Server Agent > Jobs in the Object Explorer.
Right-click Past Day stats rollup, then click Properties. Ensure that the owner of the job is the same user as the owner of the database.
Right-click Past Month stats rollup, then click Properties. Ensure that the owner of the job is the same user as the owner of the database.
Right-click Past Week stats rollup, then click Properties. Ensure that the owner of the job is the same user as the owner of the database.
I did the above steps but didn't work for me.