VMware VS4-ENT-PL-A Setup Guide - Page 39

Chapter 3 Before You Install vCenter Server 5 (Optional) You can also run the following scripts to enable database health monitoring. job_dbm_performance_data_mssql.sql process_performance_data_mssql.sql 6 For all supported editions of Microsoft SQL Server (except Microsoft SQL Server 2005 Express and Microsoft SQL Server 2008 R2 Express), run these scripts to set up scheduled jobs on the database. These scripts ensure that the SQL Server Agent service is running. job_schedule1_mssql.sql job_schedule2_mssql.sql job_schedule3_mssql.sql job_cleanup_events_mssql.sql job_topn_past_day_mssql.sql job_topn_past_week_mssql.sql job_topn_past_month_mssql.sql job_topn_past_year_mssql.sql job_property_bulletin_mssql.sql 7 For all the procedures you created in Step 4, grant the execute privilege to the vCenter Server database. grant execute on purge_stat2_proc to vCenter_db_user grant execute on purge_stat3_proc to vCenter_db_user grant execute on purge_usage_stat_proc to vCenter_db_user grant execute on stats_rollup1_proc to vCenter_db_user grant execute on stats_rollup2_proc to vCenter_db_user grant execute on stats_rollup3_proc to vCenter_db_user grant execute on cleanup_events_tasks_proc to vCenter_db_user grant execute on delete_stats_proc to vCenter_db_user grant execute on upsert_last_event_proc to vCenter_db_user grant execute on load_usage_stats_proc to vCenter_db_user grant execute on load_stats_proc to vCenter_db_user grant execute on calc_topn1_proc to vCenter_db_user grant execute on calc_topn2_proc to vCenter_db_user grant execute on calc_topn3_proc to vCenter_db_user grant execute on calc_topn4_proc to vCenter_db_user grant execute on clear_topn1_proc to vCenter_db_user grant execute on clear_topn2_proc to vCenter_db_user grant execute on clear_topn3_proc to vCenter_db_user grant execute on clear_topn4_proc to vCenter_db_user grant execute on rule_topn1_proc to vCenter_db_user grant execute on rule_topn2_proc to vCenter_db_user grant execute on rule_topn3_proc to vCenter_db_user grant execute on rule_topn4_proc to vCenter_db_user grant execute on process_license_snapshot_proc to vCenter_db_user grant execute on l_stats_rollup3_proc to vCenter_db_user grant execute on l_purge_stat2_proc to vCenter_db_user grant execute on l_purge_stat3_proc to vCenter_db_user grant execute on l_stats_rollup1_proc to vCenter_db_user grant execute on l_stats_rollup2_proc to vCenter_db_user grant execute on process_temptable0_proc to vCenter_db_user grant execute on process_temptable1_proc to vCenter_db_user grant execute on process_temptable2_proc to vCenter_db_user If you ran the script process_performance_data_mssql.sql in Step 4, grant the following execute privilege to the vCenter Server database. grant execute on process_performance_data_proc to vCenter_db_user VMware, Inc. 39