Sorry - I forgot to post the message. I sanatized the message replacing the DB name with MyDatabase and the Domain as MyDomain and the server as MyServer.
The database is SQL 2005 Version 9.00.4035.00 and is hosted on a SQL cluster.
--------------------------------------------------------------------------
Thanks everybody. I appreciate the help
--------------------------------------------------------------------------
Date 8/31/2011 10:00:00 PM
Log Job History (MyDatabase- DB Maintenance.Full Backup)
Step ID 1
Server MyServer
Job Name MyDatabase- DB Maintenance.Full Backup
Step Name Full Backup
Duration 00:00:03
Sql Severity 0
Sql Message ID 0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted 0
Message
Executed as user: MyDomain.COM\sqlclaSQLServerAgent. Microsoft (R) SQL Server Execute Package Utility Version 9.00.4035.00 for 32-bit Copyright (C) Microsoft Corp 1984-2005. All rights reserved. Started: 10:00:00 PM Progress: 2011-08-31 22:00:01.18 Source: {E034007A-D586-460E-9AF0-D6A69D8EBF54} Executing query "DECLARE @GUID UNIQUEIDENTIFIER EXECUTE msdb..sp".: 100% complete End Progress DTExec: The package execution returned DTSER_FAILURE (1). Started: 10:00:00 PM Finished: 10:00:01 PM Elapsed: 0.89 seconds. The package execution failed. The step failed.