Today I noticed that the following SQL Server jobs are failing on my Virtual Center Server:
- Event Task Cleanup
- Past Week stats rollup
They both are throwing errors that they can't find stored procedures. Event Task Cleanup is missing a stored procedure called cleanup_events_tasks_proc and Past Week stats rollup is missing purge_usage_stat_proc.
I found a SQL script on the VMware website to create the cleanup_events_task_proc but it is for Virtual Center version 4 and throws the following error when I try to run it.
Invalid column name parent_task_id.
I could not find a download for purge_usage_stat_proc.
Are there any workarounds to make this script work? Is there a place to download the scripts for version 2.5??
Thanks in advance.