Environment:
Server 2003 EE SP1
2 Machine Cluster
SQL Server 2005 EE RTM
I created a plan with three tasks: check db integrity, db backup and update stats. I want this to run nightly. When I try and save the plan, I get an error:
Guid should contain 32 digits with 4 dashes (xxxxxxx-xxxx-xxxx-xxxx-xxxxxxxxxxxx)
I can see the plan and job in Management Studio but the job schedules is “(On Demand) Not Scheduled”.
Any assistance would be appreciated.