Verifying the jobs installed in vCenter Server 5.0
To check the jobs installed in vCenter Server 5.0 using MS SQL:
- Launch SQL Server Management Studio.
- Navigate to SQL Server Agent.
Note: SQL Express does not have a SQL Server Agent so it does not have the jobs listed. Only the full edition of SQL Server has the agent and jobs.
- Ensure that the jobs listed in this table are installed:
Note: For managing an Oracle vCenter Server database, you can use Oracle SQL Developer and for managing a DB2 vCenter Server database, you can use DB2 Control Center.
Rollup Job | Corresponding File |
Event Task Cleanup myDB | job_cleanup_events_DB.sql |
Past Day stats rollup myDB | job_schedule1_DB.sql |
Past Month stats rollup myDB | job_schedule3_DB.sql |
Past Week stats rollup myDB | job_schedule2_DB.sql |
Process Performance Data myDB | job_dbm_performance_data_DB.sql |
Property Bulletin Daily Update myDB | job_property_bulletin_DB.sql |
Topn past day myDB | job_topn_past_day_DB.sql |
Topn past month myDB | job_topn_past_month_DB.sql |
Topn past week myDB | job_topn_past_week_DB.sql |
Topn past year myDB | job_topn_past_year_DB.sql |
Where DB
is db2, mssql, or oracle.
Note: Ensure that myDB references the vCenter Server database and not the primary or some other database. If these jobs reference any other database, you must delete and recreate the jobs.
Verifying the stored procedures installed in vCenter Server 5.0
To check the stored procedures installed in vCenter Server 5.0 using MS SQL:
- Navigate to vCenter DB > Programmability > Stored Procedures.
- Ensure that the stored procedures listed in this table are installed:
Stored Procedure | Corresponding File |
calc_topn1_proc | calc_topn1_proc_DB.sql |
calc_topn2_proc | calc_topn2_proc_DB.sql |
calc_topn3_proc | calc_topn3_proc_DB.sql |
calc_topn4_proc | calc_topn4_proc_DB.sql |
cleanup_events_tasks_proc | cleanup_events_DB.sql |
clear_topn1_proc | clear_topn1_proc_DB.sql |
clear_topn2_proc | clear_topn2_proc_DB.sql |
clear_topn3_proc | clear_topn3_proc_DB.sql |
clear_topn4_proc | clear_topn4_proc_DB.sql |
delete_stats_proc | delete_stats_proc_DB.sql |
process_license_snapshot_proc | process_license_snapshot_DB.sql |
process_performance_data_proc | process_performance_data_DB.sql |
process_temptable0_proc | process_temptable0_proc_DB.sql |
process_temptable1_proc | process_temptable1_proc_DB.sql |
process_temptable2_proc | process_temptable2_proc_DB.sql |
purge_stat1_proc | purge_stat1_proc_DB.sql |
purge_stat2_proc | purge_stat2_proc_DB.sql |
purge_stat3_proc | purge_stat3_proc_DB.sql |
purge_usage_stats_proc | purge_usage_stats_proc_DB.sql |
rule_topn1_proc | rule_topn1_proc_DB.sql |
rule_topn2_proc | rule_topn2_proc_DB.sql |
rule_topn3_proc | rule_topn3_proc_DB.sql |
rule_topn4_proc | rule_topn4_proc_DB.sql |
stats_rollup1_proc | stats_rollup1_proc_DB.sql |
stats_rollup2_proc | stats_rollup2_proc_DB.sql |
stats_rollup3_proc | stats_rollup3_proc_DB.sql |
upsert_last_event_proc | upsert_last_event_proc_DB.sql |
Where DB
is db2, mssql, or oracle.
If any of these jobs or stored procedures are missing, you must install them by running the corresponding .sql
file on the vCenter Server database using a database management tool such as SQL Management Studio. For more information on running the .sql
files, see the Adding the SQL Server Agent Jobs section in Updating rollup jobs after the error: Performance data is currently not available for this entity (1004382).
Note: The upsert_last_event_proc
is not required for the Oracle database.
All SQL scripts are located in the vCenter Server installation folder in C:\Program Files\VMware\Infrastructure\VirtualCenter Server\sql
. For more information on commonly used vCenter Server installation paths, see Common vCenter Server and vSphere Client Windows paths (1028185).
Ensure that the vCenter Server database is the target before executing the SQL file.