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
add comment

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.