Hi,
While trying to figure out why our performance graphs weren't being generated I noticed that all the MSSQL jobs are actually missing.
I suspect this is due to a DB server rebuild which occured a while back. The engineer has taken care of backing up & restoring the DBs but not the actual SQL Agent Jobs...
I see all the SQL job files are located in C:\Program Files\VMware\Infrastructure\VirtualCenter Server on our vCenter server box but there are so many .sql files that I'm not sure which ones I need to copy over to our MSSQL server.
Has anyone had to re-create the SQL Agent jobs for vCenter 5? If so what was the procedure?
All the info I can find on t he subject is related to vCenter 4.x and it seems the jobs aren't named the same in v5.
Thanks for any help you can provide.
the below article will walk you through recreating the jobs
Well that's the KB that confused me. It doesn't mention anything about vCenter 5 and i compared with our v4 platforms and the job sql filenames aren't the same it seems. Also there seem to be more files in v5. Does anyone know:
- how to restore the v5 jobs in SQL?
- what SQL jobs are needed for my overview graphs to show as they would in a default fresh install?
http://kb.vmware.com/kb/2006097 ?
/Rubeck
Thanks! Seems like what I'm after. I must have missed that KB...
You're welcome...
In the danish forum there's posted a script created by a user named mry for recreating these missing tables in the case you need it.
http://communities.vmware.com/thread/342569?tstart=0
/Rubeck
FYI, I've followed that last KB and all my jobs are now back to normal. Thanks again for your help.
I will make a note of that link in case I have to recreate the tables! Thanks.
