6.7

b
process_performance_data_mssql.sql
7 For all supported editions of Microsoft SQL Server except Microsoft SQL Server Express, run the
scripts to set up scheduled jobs on the database.
These scripts ensure that the SQL Server Agent service is running.
a
job_schedule1_mssql.sql
b
job_schedule2_mssql.sql
c
job_schedule3_mssql.sql
d
job_cleanup_events_mssql.sql
e
job_topn_past_day_mssql.sql
f
job_topn_past_week_mssql.sql
g
job_topn_past_month_mssql.sql
h
job_topn_past_year_mssql.sql
8 For all the procedures you created in Step 5, grant the execute privilege to the vCenter Server
database user in the vCenter Server database.
For example, to grant execute privilege for the procedures to the vpxuser user, you can run the
following script.
grant execute on insert_stats_proc to vpxuser
grant execute on purge_stat2_proc to vpxuser
grant execute on purge_stat3_proc to vpxuser
grant execute on purge_usage_stat_proc to vpxuser
grant execute on stats_rollup1_proc to vpxuser
grant execute on stats_rollup2_proc to vpxuser
grant execute on stats_rollup3_proc to vpxuser
grant execute on cleanup_events_tasks_proc to vpxuser
grant execute on delete_stats_proc to vpxuser
grant execute on upsert_last_event_proc to vpxuser
grant execute on load_usage_stats_proc to vpxuser
grant execute on load_stats_proc to vpxuser
grant execute on calc_topn1_proc to v
grant execute on calc_topn2_proc to vpxuser
grant execute on calc_topn3_proc to vpxuser
grant execute on calc_topn4_proc to vpxuser
grant execute on clear_topn1_proc to vpxuser
grant execute on clear_topn2_proc to vpxuser
grant execute on clear_topn3_proc to vpxuser
grant execute on clear_topn4_proc to vpxuser
grant execute on rule_topn1_proc to vpxuser
grant execute on rule_topn2_proc to vpxuser
grant execute on rule_topn3_proc to vpxuser
grant execute on rule_topn4_proc to vpxuser
grant execute on process_license_snapshot_proc to vpxuser
grant execute on l_stats_rollup3_proc to vpxuser
vCenter Server Installation and Setup
VMware, Inc. 98