Prev: sysmail_mailitems
Next: How do I determine default instance vs. named instance install?
From: John Bell on 23 May 2010 06:52
Hi

As the filename or extension are blank check that the job is
correctly configured.

John

On Sun, 23 May 2010 06:40:06 +0300, "Shay" <shayhanya(a)yahoo.com>
wrote:

>
>Maintenance Cleanup on Local server connection
>Cleanup Database Backup files
>Age: Older than 3 Days
>
>-1073548784
>
>Executing the query "EXECUTE master.dbo.xp_delete_file
>0,N'',N'',N'2010-05-20T00:57:22'
>" failed with the following error: "Error executing extended stored
>procedure: Invalid Parameter". Possible failure reasons: Problems with the
>query, "ResultSet" property not set correctly, parameters not set correctly,
>or connection not established correctly.
>
>
>
>Date,Source,Severity,Plan Name,SubPlan Name,Task Name,Duration
>05/23/2010 00:57:23,,Error,MaintenancePlan,Subplan_1,,01:57:20
>05/23/2010 00:57:22,,Error,,,Maintenance Cleanup Task (pandb),00:00:01
>05/22/2010 23:27:07,,Unknown,,,Back Up Database (Full) (pandb),01:30:15
>05/22/2010 23:00:05,,Unknown,,,Check Database Integrity (pandb),00:27:01
>05/22/2010 11:21:05,,Error,MaintenancePlan,Subplan_1,,01:09:00
>05/22/2010 11:21:05,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>05/22/2010 10:38:36,,Unknown,,,Back Up Database (Full) (pandb),00:42:29
>05/22/2010 10:12:06,,Unknown,,,Check Database Integrity (pandb),00:26:29
>05/22/2010 01:17:47,,Error,MaintenancePlan,Subplan_1,,02:17:40
>05/22/2010 01:17:47,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>05/21/2010 23:27:27,,Unknown,,,Back Up Database (Full) (pandb),01:50:20
>05/21/2010 23:00:10,,Unknown,,,Check Database Integrity (pandb),00:27:16
>05/21/2010 01:28:16,,Error,MaintenancePlan,Subplan_1,,02:28:12
>05/21/2010 01:28:15,,Error,,,Maintenance Cleanup Task (pandb),00:00:01
>05/20/2010 23:27:00,,Unknown,,,Back Up Database (Full) (pandb),02:01:15
>05/20/2010 23:00:06,,Unknown,,,Check Database Integrity (pandb),00:26:53
>05/20/2010 01:13:52,,Error,MaintenancePlan,Subplan_1,,02:13:48
>05/20/2010 01:13:52,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>05/19/2010 23:27:07,,Unknown,,,Back Up Database (Full) (pandb),01:46:45
>05/19/2010 23:00:07,,Unknown,,,Check Database Integrity (pandb),00:26:59
>05/19/2010 00:20:44,,Error,MaintenancePlan,Subplan_1,,01:20:41
>05/19/2010 00:20:44,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>05/18/2010 23:25:47,,Unknown,,,Back Up Database (Full) (pandb),00:54:56
>05/18/2010 23:00:04,,Unknown,,,Check Database Integrity (pandb),00:25:42
>
>
>
>"Jeffrey Williams" <jeff.williams3188(a)verizon.net> wrote in message
>news:uD0W3ii%23KHA.5476(a)TK2MSFTNGP06.phx.gbl...
>> View the history of the maintenance plan - not the history of the job.
>> You will find the actual error in that history for the task that failed.
>>
>> "Shay" <shayhanya(a)yahoo.com> wrote in message
>> news:#Dlc#Li#KHA.348(a)TK2MSFTNGP06.phx.gbl...
>>>
>>> This 2 errors
>>>
>>> Event Type: Warning
>>> Event Source: SQLSERVERAGENT
>>> Event Category: Job Engine
>>> Event ID: 208
>>> Date: 22/05/2010
>>> Time: 11:21:07
>>> User: N/A
>>> Computer: PANDB
>>> Description:
>>> SQL Server Scheduled Job 'MaintenancePlan.Subplan_1'
>>> (0x53D62013D401044FBD28485D7DBDD64F) - Status: Failed - Invoked on:
>>> 2010-05-22 10:12:01 - Message: The job failed. The Job was invoked by
>>> User PANDOR\Administrator. The last step to run was step 1 (Subplan_1).
>>>
>>> For more information, see Help and Support Center at
>>> http://go.microsoft.com/fwlink/events.asp.
>>>
>>>
>>>
>>> Event Type: Error
>>> Event Source: SQLISPackage
>>> Event Category: None
>>> Event ID: 12291
>>> Date: 22/05/2010
>>> Time: 11:21:05
>>> User: PANDOR\Administrator
>>> Computer: PANDB
>>> Description:
>>> Package "MaintenancePlan" failed.
>>>
>>> For more information, see Help and Support Center at
>>> http://go.microsoft.com/fwlink/events.asp.
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>>
>>> "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message
>>> news:k6ggv5l05eoce0e2fufp5990fnpt3n4rg4(a)4ax.com...
>>>> On Sat, 22 May 2010 15:53:45 +0300, "Shay" <shayhanya(a)yahoo.com>
>>>> wrote:
>>>>
>>>>>Hi
>>>>>
>>>>>After the maintenance run at the end when it has to delete old backup
>>>>>files,
>>>>>therer is an error. error 208.
>>>>>
>>>>>Any idea?
>>>>>
>>>>>
>>>>>SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2 and
>>>>>all
>>>>>the patches.
>>>>>
>>>>>Than'x
>>>>>Shay
>>>>>
>>>>
>>>> Hi
>>>>
>>>> What is logged in the job history, SQL Server or Windows logs? Error
>>>> 208 doesn't say much other than the is a problem!
>>>>
>>>> John
>>>>
>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>> signature database 5138 (20100522) __________
>>>>
>>>> The message was checked by ESET NOD32 Antivirus.
>>>>
>>>> http://www.eset.com
>>>>
>>>>
>>>>
>>>
>>>
>>
>> __________ Information from ESET NOD32 Antivirus, version of virus
>> signature database 5138 (20100522) __________
>>
>> The message was checked by ESET NOD32 Antivirus.
>>
>> http://www.eset.com
>>
>>
>>
>
From: Jeffrey Williams on 23 May 2010 12:37
As John stated - the task has to have the directory and type of file
defined. Make sure when you define the type you do not include the period.
Use bak instead of .bak or the procedure will try and delete files that have
two periods in them and will not remove your backup files.

"John Bell" <jbellnewsposts(a)hotmail.com> wrote in message
news:p42iv5tlql872pj8s216eoe6enodk94ld5(a)4ax.com...
> Hi
>
> As the filename or extension are blank check that the job is
> correctly configured.
>
> John
>
> On Sun, 23 May 2010 06:40:06 +0300, "Shay" <shayhanya(a)yahoo.com>
> wrote:
>
>>
>>Maintenance Cleanup on Local server connection
>>Cleanup Database Backup files
>>Age: Older than 3 Days
>>
>>-1073548784
>>
>>Executing the query "EXECUTE master.dbo.xp_delete_file
>>0,N'',N'',N'2010-05-20T00:57:22'
>>" failed with the following error: "Error executing extended stored
>>procedure: Invalid Parameter". Possible failure reasons: Problems with the
>>query, "ResultSet" property not set correctly, parameters not set
>>correctly,
>>or connection not established correctly.
>>
>>
>>
>>Date,Source,Severity,Plan Name,SubPlan Name,Task Name,Duration
>>05/23/2010 00:57:23,,Error,MaintenancePlan,Subplan_1,,01:57:20
>>05/23/2010 00:57:22,,Error,,,Maintenance Cleanup Task (pandb),00:00:01
>>05/22/2010 23:27:07,,Unknown,,,Back Up Database (Full) (pandb),01:30:15
>>05/22/2010 23:00:05,,Unknown,,,Check Database Integrity (pandb),00:27:01
>>05/22/2010 11:21:05,,Error,MaintenancePlan,Subplan_1,,01:09:00
>>05/22/2010 11:21:05,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>>05/22/2010 10:38:36,,Unknown,,,Back Up Database (Full) (pandb),00:42:29
>>05/22/2010 10:12:06,,Unknown,,,Check Database Integrity (pandb),00:26:29
>>05/22/2010 01:17:47,,Error,MaintenancePlan,Subplan_1,,02:17:40
>>05/22/2010 01:17:47,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>>05/21/2010 23:27:27,,Unknown,,,Back Up Database (Full) (pandb),01:50:20
>>05/21/2010 23:00:10,,Unknown,,,Check Database Integrity (pandb),00:27:16
>>05/21/2010 01:28:16,,Error,MaintenancePlan,Subplan_1,,02:28:12
>>05/21/2010 01:28:15,,Error,,,Maintenance Cleanup Task (pandb),00:00:01
>>05/20/2010 23:27:00,,Unknown,,,Back Up Database (Full) (pandb),02:01:15
>>05/20/2010 23:00:06,,Unknown,,,Check Database Integrity (pandb),00:26:53
>>05/20/2010 01:13:52,,Error,MaintenancePlan,Subplan_1,,02:13:48
>>05/20/2010 01:13:52,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>>05/19/2010 23:27:07,,Unknown,,,Back Up Database (Full) (pandb),01:46:45
>>05/19/2010 23:00:07,,Unknown,,,Check Database Integrity (pandb),00:26:59
>>05/19/2010 00:20:44,,Error,MaintenancePlan,Subplan_1,,01:20:41
>>05/19/2010 00:20:44,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>>05/18/2010 23:25:47,,Unknown,,,Back Up Database (Full) (pandb),00:54:56
>>05/18/2010 23:00:04,,Unknown,,,Check Database Integrity (pandb),00:25:42
>>
>>
>>
>>"Jeffrey Williams" <jeff.williams3188(a)verizon.net> wrote in message
>>news:uD0W3ii%23KHA.5476(a)TK2MSFTNGP06.phx.gbl...
>>> View the history of the maintenance plan - not the history of the job.
>>> You will find the actual error in that history for the task that failed.
>>>
>>> "Shay" <shayhanya(a)yahoo.com> wrote in message
>>> news:#Dlc#Li#KHA.348(a)TK2MSFTNGP06.phx.gbl...
>>>>
>>>> This 2 errors
>>>>
>>>> Event Type: Warning
>>>> Event Source: SQLSERVERAGENT
>>>> Event Category: Job Engine
>>>> Event ID: 208
>>>> Date: 22/05/2010
>>>> Time: 11:21:07
>>>> User: N/A
>>>> Computer: PANDB
>>>> Description:
>>>> SQL Server Scheduled Job 'MaintenancePlan.Subplan_1'
>>>> (0x53D62013D401044FBD28485D7DBDD64F) - Status: Failed - Invoked on:
>>>> 2010-05-22 10:12:01 - Message: The job failed. The Job was invoked by
>>>> User PANDOR\Administrator. The last step to run was step 1
>>>> (Subplan_1).
>>>>
>>>> For more information, see Help and Support Center at
>>>> http://go.microsoft.com/fwlink/events.asp.
>>>>
>>>>
>>>>
>>>> Event Type: Error
>>>> Event Source: SQLISPackage
>>>> Event Category: None
>>>> Event ID: 12291
>>>> Date: 22/05/2010
>>>> Time: 11:21:05
>>>> User: PANDOR\Administrator
>>>> Computer: PANDB
>>>> Description:
>>>> Package "MaintenancePlan" failed.
>>>>
>>>> For more information, see Help and Support Center at
>>>> http://go.microsoft.com/fwlink/events.asp.
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>>
>>>> "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message
>>>> news:k6ggv5l05eoce0e2fufp5990fnpt3n4rg4(a)4ax.com...
>>>>> On Sat, 22 May 2010 15:53:45 +0300, "Shay" <shayhanya(a)yahoo.com>
>>>>> wrote:
>>>>>
>>>>>>Hi
>>>>>>
>>>>>>After the maintenance run at the end when it has to delete old backup
>>>>>>files,
>>>>>>therer is an error. error 208.
>>>>>>
>>>>>>Any idea?
>>>>>>
>>>>>>
>>>>>>SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2
>>>>>>and
>>>>>>all
>>>>>>the patches.
>>>>>>
>>>>>>Than'x
>>>>>>Shay
>>>>>>
>>>>>
>>>>> Hi
>>>>>
>>>>> What is logged in the job history, SQL Server or Windows logs? Error
>>>>> 208 doesn't say much other than the is a problem!
>>>>>
>>>>> John
>>>>>
>>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>>> signature database 5138 (20100522) __________
>>>>>
>>>>> The message was checked by ESET NOD32 Antivirus.
>>>>>
>>>>> http://www.eset.com
>>>>>
>>>>>
>>>>>
>>>>
>>>>
>>>
>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>> signature database 5138 (20100522) __________
>>>
>>> The message was checked by ESET NOD32 Antivirus.
>>>
>>> http://www.eset.com
>>>
>>>
>>>
>>
From: Shay on 26 May 2010 00:11
thanx to all
problem solved
I changed the ext. of the file.

Shay
"Jeffrey Williams" <jeff.williams3188(a)verizon.net> wrote in message
news:EA22471C-6E34-4222-A978-26E65B4C1E71(a)microsoft.com...
> As John stated - the task has to have the directory and type of file
> defined. Make sure when you define the type you do not include the
> period. Use bak instead of .bak or the procedure will try and delete files
> that have two periods in them and will not remove your backup files.
>
> "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message
> news:p42iv5tlql872pj8s216eoe6enodk94ld5(a)4ax.com...
>> Hi
>>
>> As the filename or extension are blank check that the job is
>> correctly configured.
>>
>> John
>>
>> On Sun, 23 May 2010 06:40:06 +0300, "Shay" <shayhanya(a)yahoo.com>
>> wrote:
>>
>>>
>>>Maintenance Cleanup on Local server connection
>>>Cleanup Database Backup files
>>>Age: Older than 3 Days
>>>
>>>-1073548784
>>>
>>>Executing the query "EXECUTE master.dbo.xp_delete_file
>>>0,N'',N'',N'2010-05-20T00:57:22'
>>>" failed with the following error: "Error executing extended stored
>>>procedure: Invalid Parameter". Possible failure reasons: Problems with
>>>the
>>>query, "ResultSet" property not set correctly, parameters not set
>>>correctly,
>>>or connection not established correctly.
>>>
>>>
>>>
>>>Date,Source,Severity,Plan Name,SubPlan Name,Task Name,Duration
>>>05/23/2010 00:57:23,,Error,MaintenancePlan,Subplan_1,,01:57:20
>>>05/23/2010 00:57:22,,Error,,,Maintenance Cleanup Task (pandb),00:00:01
>>>05/22/2010 23:27:07,,Unknown,,,Back Up Database (Full) (pandb),01:30:15
>>>05/22/2010 23:00:05,,Unknown,,,Check Database Integrity (pandb),00:27:01
>>>05/22/2010 11:21:05,,Error,MaintenancePlan,Subplan_1,,01:09:00
>>>05/22/2010 11:21:05,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>>>05/22/2010 10:38:36,,Unknown,,,Back Up Database (Full) (pandb),00:42:29
>>>05/22/2010 10:12:06,,Unknown,,,Check Database Integrity (pandb),00:26:29
>>>05/22/2010 01:17:47,,Error,MaintenancePlan,Subplan_1,,02:17:40
>>>05/22/2010 01:17:47,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>>>05/21/2010 23:27:27,,Unknown,,,Back Up Database (Full) (pandb),01:50:20
>>>05/21/2010 23:00:10,,Unknown,,,Check Database Integrity (pandb),00:27:16
>>>05/21/2010 01:28:16,,Error,MaintenancePlan,Subplan_1,,02:28:12
>>>05/21/2010 01:28:15,,Error,,,Maintenance Cleanup Task (pandb),00:00:01
>>>05/20/2010 23:27:00,,Unknown,,,Back Up Database (Full) (pandb),02:01:15
>>>05/20/2010 23:00:06,,Unknown,,,Check Database Integrity (pandb),00:26:53
>>>05/20/2010 01:13:52,,Error,MaintenancePlan,Subplan_1,,02:13:48
>>>05/20/2010 01:13:52,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>>>05/19/2010 23:27:07,,Unknown,,,Back Up Database (Full) (pandb),01:46:45
>>>05/19/2010 23:00:07,,Unknown,,,Check Database Integrity (pandb),00:26:59
>>>05/19/2010 00:20:44,,Error,MaintenancePlan,Subplan_1,,01:20:41
>>>05/19/2010 00:20:44,,Error,,,Maintenance Cleanup Task (pandb),00:00:00
>>>05/18/2010 23:25:47,,Unknown,,,Back Up Database (Full) (pandb),00:54:56
>>>05/18/2010 23:00:04,,Unknown,,,Check Database Integrity (pandb),00:25:42
>>>
>>>
>>>
>>>"Jeffrey Williams" <jeff.williams3188(a)verizon.net> wrote in message
>>>news:uD0W3ii%23KHA.5476(a)TK2MSFTNGP06.phx.gbl...
>>>> View the history of the maintenance plan - not the history of the job.
>>>> You will find the actual error in that history for the task that
>>>> failed.
>>>>
>>>> "Shay" <shayhanya(a)yahoo.com> wrote in message
>>>> news:#Dlc#Li#KHA.348(a)TK2MSFTNGP06.phx.gbl...
>>>>>
>>>>> This 2 errors
>>>>>
>>>>> Event Type: Warning
>>>>> Event Source: SQLSERVERAGENT
>>>>> Event Category: Job Engine
>>>>> Event ID: 208
>>>>> Date: 22/05/2010
>>>>> Time: 11:21:07
>>>>> User: N/A
>>>>> Computer: PANDB
>>>>> Description:
>>>>> SQL Server Scheduled Job 'MaintenancePlan.Subplan_1'
>>>>> (0x53D62013D401044FBD28485D7DBDD64F) - Status: Failed - Invoked on:
>>>>> 2010-05-22 10:12:01 - Message: The job failed. The Job was invoked by
>>>>> User PANDOR\Administrator. The last step to run was step 1
>>>>> (Subplan_1).
>>>>>
>>>>> For more information, see Help and Support Center at
>>>>> http://go.microsoft.com/fwlink/events.asp.
>>>>>
>>>>>
>>>>>
>>>>> Event Type: Error
>>>>> Event Source: SQLISPackage
>>>>> Event Category: None
>>>>> Event ID: 12291
>>>>> Date: 22/05/2010
>>>>> Time: 11:21:05
>>>>> User: PANDOR\Administrator
>>>>> Computer: PANDB
>>>>> Description:
>>>>> Package "MaintenancePlan" failed.
>>>>>
>>>>> For more information, see Help and Support Center at
>>>>> http://go.microsoft.com/fwlink/events.asp.
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>>
>>>>> "John Bell" <jbellnewsposts(a)hotmail.com> wrote in message
>>>>> news:k6ggv5l05eoce0e2fufp5990fnpt3n4rg4(a)4ax.com...
>>>>>> On Sat, 22 May 2010 15:53:45 +0300, "Shay" <shayhanya(a)yahoo.com>
>>>>>> wrote:
>>>>>>
>>>>>>>Hi
>>>>>>>
>>>>>>>After the maintenance run at the end when it has to delete old backup
>>>>>>>files,
>>>>>>>therer is an error. error 208.
>>>>>>>
>>>>>>>Any idea?
>>>>>>>
>>>>>>>
>>>>>>>SQL 2005 64 bit with sp3 and all the patches on win2003 R2 64bit sp2
>>>>>>>and
>>>>>>>all
>>>>>>>the patches.
>>>>>>>
>>>>>>>Than'x
>>>>>>>Shay
>>>>>>>
>>>>>>
>>>>>> Hi
>>>>>>
>>>>>> What is logged in the job history, SQL Server or Windows logs? Error
>>>>>> 208 doesn't say much other than the is a problem!
>>>>>>
>>>>>> John
>>>>>>
>>>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>>>> signature database 5138 (20100522) __________
>>>>>>
>>>>>> The message was checked by ESET NOD32 Antivirus.
>>>>>>
>>>>>> http://www.eset.com
>>>>>>
>>>>>>
>>>>>>
>>>>>
>>>>>
>>>>
>>>> __________ Information from ESET NOD32 Antivirus, version of virus
>>>> signature database 5138 (20100522) __________
>>>>
>>>> The message was checked by ESET NOD32 Antivirus.
>>>>
>>>> http://www.eset.com
>>>>
>>>>
>>>>
>>>
>
> __________ Information from ESET NOD32 Antivirus, version of virus
> signature database 5139 (20100523) __________
>
> The message was checked by ESET NOD32 Antivirus.
>
> http://www.eset.com
>
>
>


First  |  Prev  | 
Pages: 1 2
Prev: sysmail_mailitems
Next: How do I determine default instance vs. named instance install?