First off - I'm a developer, not a DBA or server admin, so I'm feeling kinda outta my elemenet here. Anyways, I'm trying to create a Maintenance Plan on a Sql Server 2005 machine (it's the first one on this box). After failing miserably to get the plan I wanted to work, I've deleted it, and started off w/a very basic one using the wizard. Its supposed to do 1 thing, do a check database integrity task.
I've gone into the reporting options in Management Studio, and told it to generate a text file report, and to log extended information. However, after the job fails, I go and look for the log file, and nothing is there. When I look in the log viewer (in Management Studio) for "SQL Server" and "SQL Agent", I dont' see any entries for around the time I tried to execute the maintanence plan. When I look at the Application Log, I see an entry that states:
Description: SQL Server Scheduled Job 'MaintenancePlan.Subplan_1' (0xCB266AFE28CAB2449D241CB1293879B5) - Status: Failed - Invoked on: 2009-10-09 15:10:43 - Message: The job failed. The Job was invoked by User sa. The last step to run was step 1 (Subplan_1).
When I look in the Job History for the plan, I see the message:
Unable to start execution of step 1(reason: line(1): Syntax error). The step failed
I've set the plan's connection (by clicking the "Manage Connections" button) for a local server connection using Windows Authentication. Can someone please help me determine what I'm missing/where I screwed up?