ปัญหานี้เกิดจากการ Upgrade จาก SQL 2005 Express ไปเป็นเวอร์ชั่นอื่น
เนื่องจากใน SQL 2005 Express ไม่สามารถใช้งาน SQL Server Agent ได้ ข้อมูลส่วนนี้จึงโดนจัดการโดย VirtualCenter Server service ดังนั้นเมื่อได้ทำการ Upgrade SQL จึงต้องเพิ่ม Job ใน SQL Server Agent
ที่มา Vmware
Adding the SQL Server Agent Jobs
This section describes how to install 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 File > Open > File.
- Navigate to the location of the jobs:
- For vCenter 2.5, go to C:Program FilesVMwareInfrastructureVirtualCenter ServerdbupgradeUpgrade-v3-to-v4PL-SQL
- For vCenter 4.0, go to C:Program FilesVMwareInfrastructureVirtualCenter Server
- Open job_schedule1_mssql.sql.
- Ensure that the VirtualCenter Database is selected and that Master is not selected.
- Click Execute Query.
- Follow Steps 1 to 6 for job_schedule2_mssql.sql and job_schedule3_mssql.sql.
- After all three jobs are created, navigate to SQL Server Agent > Jobs in the Object Explorer.
- Right-click Past Day stats rollup, then click Properties. Ensure that the owner of the job is the same user as the owner of the database.
- Right-click Past Month stats rollup, then click Properties. Ensure that the owner of the job is the same user as the owner of the database.
- Right-click Past Week stats rollup, then click Properties. Ensure that the owner of the job is the same user as the owner of the database.