Can somebody find where it fails, please?

Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
'PAC_APPS2' as 'PAC01\Administrator' (trusted)
Starting maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:01 AM
[1] Database IER: Database Backup...
Destination:
[E:\MSSQLSERVER\DATA\MSSQL\BACKUP\IER\IER_db_20070 5270200.BAK]
** Execution Time: 0 hrs, 0 mins, 3 secs **
[2] Database IER: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 2 secs **
[3] Database MCI: Database Backup...
[4] Database SR_PAC: Database Backup...
Destination:
[E:\MSSQLSERVER\DATA\MSSQL\BACKUP\SR_PAC\SR_PAC_db _200705270200.BAK]
** Execution Time: 0 hrs, 0 mins, 2 secs **
[5] Database SR_PAC: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 1 secs **
[6] Database Survey: Database Backup...
Destination:
[E:\MSSQLSERVER\DATA\MSSQL\BACKUP\Survey\Survey_db _200705270200.BAK]
** Execution Time: 0 hrs, 0 mins, 2 secs **
[7] Database Survey: Verifying Backup...
** Execution Time: 0 hrs, 0 mins, 2 secs **
[8] Database ServiceReq: Database Backup...
[9] Database whosnext: Database Backup...
Deleting old text reports... 1 file(s) deleted.
End of maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:34 AM
SQLMAINT.EXE Process Exit Code: 1 (Failed)
Hi Dave
"Dave" wrote:

> Microsoft (R) SQLMaint Utility (Unicode), Version Logged on to SQL Server
> 'PAC_APPS2' as 'PAC01\Administrator' (trusted)
> Starting maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:01 AM
> [1] Database IER: Database Backup...
> Destination:
> [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\IER\IER_db_20070 5270200.BAK]
> ** Execution Time: 0 hrs, 0 mins, 3 secs **
> [2] Database IER: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 2 secs **
> [3] Database MCI: Database Backup...
> [4] Database SR_PAC: Database Backup...
> Destination:
> [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\SR_PAC\SR_PAC_db _200705270200.BAK]
> ** Execution Time: 0 hrs, 0 mins, 2 secs **
> [5] Database SR_PAC: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 1 secs **
> [6] Database Survey: Database Backup...
> Destination:
> [E:\MSSQLSERVER\DATA\MSSQL\BACKUP\Survey\Survey_db _200705270200.BAK]
> ** Execution Time: 0 hrs, 0 mins, 2 secs **
> [7] Database Survey: Verifying Backup...
> ** Execution Time: 0 hrs, 0 mins, 2 secs **
> [8] Database ServiceReq: Database Backup...
> [9] Database whosnext: Database Backup...
> Deleting old text reports... 1 file(s) deleted.
> End of maintenance plan 'DB Maintenance Plan_weekly' on 5/27/2007 2:00:34 AM
> SQLMAINT.EXE Process Exit Code: 1 (Failed)
None of the steps seems to have failed, so it may be the job notifications
that are causing the problem! Have you checked the SQL Server Error Log for
any messages?
John
|||Thanks, I will check that
-Dave
"John Bell" wrote:

> Hi Dave
> "Dave" wrote:
>
> None of the steps seems to have failed, so it may be the job notifications
> that are causing the problem! Have you checked the SQL Server Error Log for
> any messages?
> John