Loading

×Sorry to interrupt
CSS Error

Refresh

Cookie Preference Center

General Information on cookies

When you visit our website, we use cookies to ensure that we give you the best experience. This information does not usually directly identify you, but it can give you a more personalized web experience. Because we respect your right to privacy, you can choose not to allow some types of cookies by clicking on the different category headings to find out more and change your settings. However, blocking some types of cookies may impact your experience on the site and the services we are able to offer. Further information can be found in our

Cookie Policy.

Strictly Necessary

Strictly Necessary

Always Active

Strictly Necessary

Strictly necessary cookies are always enabled since they are essential for our website to function. They enable core functionality such as security, network management, and website accessibility. You can set your browser to block or alert you about these cookies, but this may affect how the website functions. For more information please visit www.aboutcookies.org or www.allaboutcookies.org.

Cookie Details‎

Performance

Performance

Performance

Performance cookies are used to analyze the user experience to improve our website by collecting and reporting information on how you use it. They allow us to know which pages are the most and least popular, see how visitors move around the site, optimize our website and make it easier to navigate.

Cookie Details‎

Please confirm your settings by refreshing the page.

Functional

Functional

Functional

Functional cookies help us keep track of your past browsing choices so we can improve usability and customize your experience. These cookies enable the website to remember your preferred settings, language preferences, location and other customizable elements such as font or text size. If you do not allow these cookies, then some or all of these services may not function properly.

Cookie Details‎

Advertising

Advertising

Advertising

Advertising cookies are used to send you relevant advertising and promotional information. They may be set through our site by third parties to build a profile of your interests and show you relevant advertisements on other sites. These cookies do not directly store personal information, but their function is based on uniquely identifying your browser and internet device.

Cookie Details‎

Advertising Cookies

Consent Leg.Interest

Select All Vendors

Select All Vendors

Select All Hosts

Select All

Clear Filters

Information storage and access

Apply

Confirm My Choices Reject All Allow All

My Subscriptions

Loading

Knowledge Base

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

Last Updated: 3/20/2024Categories: TroubleshootingTotal Views: 29918Language:
Chinese (Simplified)JapaneseEnglish

Subscribe to get an email
newsletter with new updates

Please provide article feedback:

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

To check the jobs installed in vCenter Server 4.1 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

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

To check the stored procedures installed in vCenter Server 4.1 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_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 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.

Related Information

For more information, see Verifying jobs and stored procedures installed in vCenter Server 5.1 and 5.5 (2033096).

"Performance data is currently not available for this entity" error after updating rollup in vSphere
vCenter Server 4.1 installation rolls back when updating the database
Verifying vCenter Server 2.5 jobs and stored procedures
Verifying jobs and stored procedures installed in vCenter Server 5.1, 5.5 and 6.x
VMware vCenter Server 4.1.x のジョブおよびストアド プロシージャを確認する
验证 VMware vCenter Server 4.1.x 中的作业和存储过程

Detectable by VMware SkylineTM

Actions

Copy

link to clipboard
copied!

Print

Language:
Chinese (Simplified)JapaneseEnglish

Attachments

Additional Resources

KB
•
End Of General Availability of the Free vSphere Hypervisor (ESXi 7.x and 8.x) (2107518)

KB
•
打开虚拟机时报错：无法打开 /dev/vmmon：没有此文件或目录 (2146460)

Results 1-2 of 2

Ask The Community

Get answers quickly from VMware experts in the community

Post Subject

CONTINUE IN COMMUNITIES

Related Products:

VMware vCenter Server

Related Versions:

VMware vCenter Server 4.1.x

Take Our Survey

Support Assistant