VMware Cloud Community
griffinboy
Enthusiast
Enthusiast
Jump to solution

vCenter Server 5 - MSSQL Jobs Missing

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.

VCPID: 40118 (VCP310, VCP4)
Reply
0 Kudos
1 Solution

Accepted Solutions
6 Replies
Troy_Clavell
Immortal
Immortal
Jump to solution

the below article will walk you through recreating the jobs

http://kb.vmware.com/kb/1004382

Reply
0 Kudos
griffinboy
Enthusiast
Enthusiast
Jump to solution

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?

VCPID: 40118 (VCP310, VCP4)
Reply
0 Kudos
Rubeck
Virtuoso
Virtuoso
Jump to solution

Reply
0 Kudos
griffinboy
Enthusiast
Enthusiast
Jump to solution

Thanks! Seems like what I'm after. I must have missed that KB...

VCPID: 40118 (VCP310, VCP4)
Reply
0 Kudos
Rubeck
Virtuoso
Virtuoso
Jump to solution

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

griffinboy
Enthusiast
Enthusiast
Jump to solution

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.

VCPID: 40118 (VCP310, VCP4)
Reply
0 Kudos