title: SQL server 2005 agent not working
body: <p>Sql server 2005  service pack 2 version: 9.00.3042.00</p>
  
  <p>All maintenance plans fail with the same error.</p>
  
  <p>The details of the error are:-</p>
  
  <hr>
  
  <p>Execute Maintenance Plan</p>
  
  <ul>
  <li>Execute maintenance plan. test7 (Error)
  Messages
  Execution failed. See the maintenance plan and SQL Server Agent job history logs for details.</li>
  </ul>
  
  <p>The advanced information section shows the following;</p>
  
  <h2>Job 'test7.Subplan_1' failed. (SqlManagerUI)</h2>
  
  <p>Program Location:
  at Microsoft.SqlServer.Management.SqlManagerUI.MaintenancePlanMenu_Run.PerformActions() </p>
  
  <p>At this point the following appear in the windows event log:
  Event Type: Error
  Event Source:   SQLISPackage
  Event Category: None
  Event ID:   12291
  Date:       28/05/2009
  Time:       16:09:08
  User:       'DOMAINNAME\username'
  Computer:   SQLSERVER4
  Description:
  Package "test7" failed.</p>
  
  <h1>and also this:</h1>
  
  <p>Event Type: Warning
  Event Source:   SQLSERVERAGENT
  Event Category: Job Engine 
  Event ID:   208
  Date:       28/05/2009
  Time:       16:09:10
  User:       N/A
  Computer:   SQLSERVER4
  Description:</p>
  
  <h2>SQL Server Scheduled Job 'test7.Subplan_1' (0x96AE7493BFF39F4FBBAE034AB6DA1C1F) - Status: Failed - Invoked on: 2009-05-28 16:09:02 - Message: The job failed.  The Job was invoked by User 'DOMAINNAME\username'.  The last step to run was step 1 (Subplan_1).</h2>
  
  <p>There are no entries in the SQl Agent log at all.</p>