VMware Communities > Blogs > Knorrhane > Tags

Blog Posts

Knorrhane

2 Posts tagged with the sql tag
0

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

  1. 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.
  2. Click New Query.
  3. 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.
  4. Select your VirtualCenter database from the Database dropdown.
  5. Execute the script.
  6. 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


0 Comments Permalink
0

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.

0 Comments Permalink
Click to view nikkar's profile

nikkar

Member since: Apr 12, 2005

Things that happens and is good to be remembered.

View nikkar's profile