SQL Server Maintenance Plans  
Author Message
Thatch





PostPosted: Tue Aug 26 14:48:10 CDT 2003 Top

SQL Server >> SQL Server Maintenance Plans

I know this is a known bug in SQL Server, but how do you
get around this
error:

Event Type: Warning
Event Source: SQLSERVERAGENT
Event Category: Job Engine
Event ID: 208
Date: 8/25/2003
Time: 2:00:00 AM
User: N/A
Computer: SRV913
Description:
SQL Server Scheduled Job 'DB Backup Job for DB Maintenance
Plan 'DB
Maintenance Plan2'' (0x91845FF9107D0744AA1B6C04595CFA25) -
Status:
Failed - Invoked on: 2003-08-25 02:00:00 - Message: The
job failed. The
Job was invoked by Schedule 44 (Schedule 1). The last step
to run was
step 1 (Step 1).

How do I determine which of my maintenance plans this is?
All of my
plans now have meaningful names and there is not one
named - DB
Maintenance Plan2. How do I determine which plan used to
have that
name? Or do I have delete all plans and start over again
because I can
not identify which job this error message is referring to.

SQL Server299  
 
 
Dinesh





PostPosted: Tue Aug 26 14:48:10 CDT 2003 Top

SQL Server >> SQL Server Maintenance Plans Diana,

What bug are you talking about?Do you see any more details in the sql job
history in enterprise manager?Do you see any output in the below query:

SELECT *
FROM msdb..sysdbmaintplans
WHERE plan_name='DB Maintenance Plan2'

--
Dinesh.
SQL Server FAQ at
http://www.tkdinesh.com



> I know this is a known bug in SQL Server, but how do you
> get around this
> error:
>
> Event Type: Warning
> Event Source: SQLSERVERAGENT
> Event Category: Job Engine
> Event ID: 208
> Date: 8/25/2003
> Time: 2:00:00 AM
> User: N/A
> Computer: SRV913
> Description:
> SQL Server Scheduled Job 'DB Backup Job for DB Maintenance
> Plan 'DB
> Maintenance Plan2'' (0x91845FF9107D0744AA1B6C04595CFA25) -
> Status:
> Failed - Invoked on: 2003-08-25 02:00:00 - Message: The
> job failed. The
> Job was invoked by Schedule 44 (Schedule 1). The last step
> to run was
> step 1 (Step 1).
>
> How do I determine which of my maintenance plans this is?
> All of my
> plans now have meaningful names and there is not one
> named - DB
> Maintenance Plan2. How do I determine which plan used to
> have that
> name? Or do I have delete all plans and start over again
> because I can
> not identify which job this error message is referring to.
>