Knowledge Base

The VMware Knowledge Base provides support solutions, error messages and troubleshooting guides

Search the VMware Knowledge Base (KB)

View by Article ID

Verifying jobs and stored procedures in VMware vCenter Server 4.1.x (1029824)

Purpose

vCenter Server offloads many data maintenance tasks to the database itself by installing stored procedures and jobs to kick off the stored procedures. For example, these procedures move data between tables or delete old data.

This article contain the full list of jobs and stored procedures for vCenter Server 4.1.

Resolution

Verifying the jobs installed in vCenter Server 4.1

Launch SQL Server Management Studio, navigate to SQL server Agent, and ensure that these jobs are installed:

Note: For managing an Oracle vCenter Server database, you can use an Oracle SQL Developer and for managing a DB2 vCenter Server database, you can use DB2 Control Center.

Rollup Job	Corresponding file
Past Day stats rollup <myDB>	Job_schedule1_<DB>.sql
Past Week stats rollup <myDB>	Job_schedule2_<DB>.sql
Past Month stats rollup <myDB>	Job_schedule3_<DB>.sql
Event Task Cleanup <myDB>	job_cleanup_events_<DB>.sql
Topn past day <myDB>	job_topn_pastday_<DB>.sql
Topn past month <myDB>	job_topn_pastmonth_< DB >.sql
Topn past week <myDB>	job_topn_pastweek_< DB >.sql
Topn past year <myDB>	job_topn_pastyear_< DB >.sql

Where <DB> is either db2, mssql, or oracle

Note: Make sure that <myDB> references the vCenter Server database and not the master or some other database. If the above jobs reference any other database, you must delete and recreate the jobs.

If any of these jobs are missing, see Updating rollup jobs after the error: Performance data is currently not available for this entity (1004382).

Verifying the stored procedures installed in vCenter Server 4.1

Navigate to vCenter DB > Programmability > Stored Procedures and ensure that these procedures 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_proc_<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_stat_proc	purge_usage_stat_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 either db2, mssql, or oracle

If any of the above stored procedures are missing, they must be installed.

Note: The upsert_last_event_proc procedure is not required for the Oracle database.

All SQL scripts are located in the vCenter installation folder. For each job or stored procedure that you want to install you must run the corresponding file against the vCenter Server database. 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.

Update History

09/06/2012 - Added link to KB 1004382 09/27/2012 - Added link to KB 2033096 in See Also section

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.

Feedback

1 2 3 4 5
36 Ratings

1 2 3 4 5
36 Ratings

Actions

Bookmark Document

KB:

Did this article help you?
This article resolved my issue. This article did not resolve my issue. This article helped but additional information was required to resolve my issue.
What can we do to improve this information? (4000 or fewer characters)