The msdb is used to create the agent jobs and not much else.
NOTE: before you run any scripts your VC login must have
Owner rights on
msdb as described in the permissions kb 1003052 for all the same reasons.
Do you have the three agent jobs? There should be:
Past stats Day rollup
Past stats Month rollup
Past stats Year rollup
If not, you can find them in your install dir at "C:\Program Files\VMware\Infrastructure\VirtualCenter Server" as "job_schedule<1,2,3>_mssql.sql"
To run them open SQL Manager (studio) as your
VCuser (not SA or Administrator), open query analizer, paste the first script, select your VCDB and execute the script. Do this for the other two scripts.
If you have the jobs, make sure they are running as your VCuser.
If you have the jobs and things still don't work, check your VC stored procedures, I have the following listed under VCDB/Programmability/Stored Procedures:
delete_stats_proc
load_stats_proc
purge_stats1_proc
purge_stats2_proc
purge_stats3_proc
stats_rollup1_proc
stats_rollup2_proc
stats_rollup3_proc
Also, what user context are they running under? they are listed as user.delete_stats_proc.
If you are missing any of them you can find them in the same directory as the job scripts as
delete_stats_proc = delete_stats_proc_mssql.sql
load_stats_proc = load_stats_proc_mssql.sql
purge_stats1_proc = purge_stat1_proc_mssql.sql
purge_stats2_proc = purge_stat2_proc_mssql.sql
purge_stats3_proc = purge_stat3_proc_mssql.sql
stats_rollup1_proc = stats_rollup1_proc_mssql.sql
stats_rollup2_proc = stats_rollup2_proc_mssql.sql
stats_rollup3_proc = stats_rollup3_proc_mssql.sql
Run them in the same way as the jobs described above.
I have two more I think were installed from VC2.0.x because they don't exist in the VC dir.
vpx_rollup_sample_group_by_entity
vpx_stats_rollup_by_entity
Let us know what your investigation finds.
