Take the 2-minute tour ×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

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\

    1. Open job_schedule1_mssql.sql. ( Ensure that the VirtualCenter Database (for example, VCDB) is selected and that Master is not selected.)

    2. Right-click the VirtualCenter Database and select New Query.

    3. 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.

share|improve this question

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Browse other questions tagged or ask your own question.