How to add the sql agent jobs manually

nikkar — Thu, 12 Jun 2008 07:23:00 GMT

Adding the SQL Server Agent Jobs To add a SQL Server Agent Job:

Open SQL Management Studio using the database login used by VirtualCenter to connect to the database (typically not SA or Administrator). See Administrative Credentials are required for Oracle and SQL Server databases when installing or upgrading Virtual Center (1003052) to ensure you have the correct permissions.
Click New Query.
Copy the contents of job_schedule1_mssql.sql into your query window. The script is located in the install directory. The default location is C:\Program Files\VMware\Infrastructure\VirtualCenter Server.
Select your VirtualCenter database from the Database dropdown.
Execute the script.
Repeat steps 2-5 for job_schedule2_mssql.sql and job_schedule3_mssql.sql.

Note: This article does not apply to installations using Oracle or Microsoft SQL Server 2005 Express. Note: The SQL Server Agent is not available in Microsoft SQL Server 2005 Express. Historic data is managed by the VirtualCenter Server service.

http://kb.vmware.com/selfservice/microsites/search.do?language=en_US&cmd=displayKC&externalId=1004382

Drawbacks using SQL server 2005 express edition as database for virtual center 2.5

nikkar — Mon, 05 May 2008 17:22:00 GMT

When using sql server 2005 express you get no performance data, for the past week, month or more.
This depends on the lack of sql server agent in express edition.

Knorrhane

How to add the sql agent jobs manually

Drawbacks using SQL server 2005 express edition as database for virtual center 2.5