Verifying the jobs installed in vCenter Server 4.1
To check the jobs installed in vCenter Server 4.1 using MS SQL:
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).
To check the stored procedures installed in vCenter Server 4.1 using MS SQL:
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 |