August 26, 2003 at 1:19 pm
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.
August 26, 2003 at 2:58 pm
Was this an old name? I htink this is probably left over from an old maintenance plan. If under the Maintenance Plans folder (under Mangaement), there is not a maintenance plan named DB Main Plan 2, then delete this job.
Steve Jones
August 27, 2003 at 5:19 am
Check this with your SA, because it seems that you're not member of sqladmin role (this maybe why you can't see all the jobs that running under \Sql Server Agent\Jobs).
Hope, this will help.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply