{"id":325,"date":"2014-05-22T15:30:28","date_gmt":"2014-05-22T19:30:28","guid":{"rendered":"http:\/\/www.amixa.com\/blog\/?p=325"},"modified":"2014-05-22T15:30:28","modified_gmt":"2014-05-22T19:30:28","slug":"ms-sql-server-maintenance-cleanup-task-job-failure-and-how-to-fix-it","status":"publish","type":"post","link":"https:\/\/www.amixa.com\/blog\/2014\/05\/22\/ms-sql-server-maintenance-cleanup-task-job-failure-and-how-to-fix-it\/","title":{"rendered":"MS SQL Server MAINTENANCE CLEANUP TASK job failure and how to fix it!"},"content":{"rendered":"<p style=\"margin: 0in 0in 8pt;\"><span style=\"color: #000000; font-family: Calibri; font-size: medium;\">If you get this maintenance plan error for MAINTENANCE CLEANUP TASK within your error logs and your maintenance jobs are under Microsoft SQL Server (MSSQL) I have an easy fix for you.<\/span><\/p>\n<p style=\"margin: 0in 0in 8pt;\">\n<p style=\"margin: 0in 0in 8pt;\"><span style=\"color: #000000; font-family: Calibri; font-size: medium;\">This is the error:\u00a0<\/span><\/p>\n<p style=\"margin: 0in 0in 8pt;\">\n<p style=\"margin: 0in 0in 8pt;\"><em><strong><span style=\"color: #000000; font-family: Calibri; font-size: medium;\">Executing the query &#8220;EXECUTE master.dbo.xp_delete_file 0,N&#8221;,N&#8221;,N&#8217;2014&#8230;&#8221; failed with the following error: &#8220;Error executing extended stored procedure: Invalid Parameter&#8221;. Possible failure reasons: Problems with the query, &#8220;ResultSet&#8221; property not set correctly, parameters not set correctly, or connection not established correctly.<\/span><\/strong><\/em><\/p>\n<p style=\"margin: 0in 0in 8pt;\"><span style=\"color: #000000; font-family: Calibri; font-size: medium;\">\u00a0<\/span><\/p>\n<p style=\"margin: 0in 0in 8pt;\"><span style=\"color: #000000; font-family: Calibri; font-size: medium;\">Make sure the following fields are completed (file path) and that you are using *.* in the extension.<\/span><\/p>\n<p style=\"margin: 0in 0in 8pt;\"><a href=\"http:\/\/www.amixa.com\/blog\/wp-content\/uploads\/2014\/05\/SQL-ISSUE.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-326\" src=\"http:\/\/www.amixa.com\/blog\/wp-content\/uploads\/2014\/05\/SQL-ISSUE.jpg\" alt=\"SQL ISSUE\" width=\"564\" height=\"650\" srcset=\"https:\/\/www.amixa.com\/blog\/wp-content\/uploads\/2014\/05\/SQL-ISSUE.jpg 564w, https:\/\/www.amixa.com\/blog\/wp-content\/uploads\/2014\/05\/SQL-ISSUE-260x300.jpg 260w\" sizes=\"auto, (max-width: 564px) 100vw, 564px\" \/><\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>If you get this maintenance plan error for MAINTENANCE CLEANUP TASK within your error logs and your maintenance jobs are under Microsoft SQL Server (MSSQL) I have an easy fix for you. This is the error:\u00a0 Executing the query &#8220;EXECUTE master.dbo.xp_delete_file 0,N&#8221;,N&#8221;,N&#8217;2014&#8230;&#8221; failed with the following error: &#8220;Error executing extended stored procedure: Invalid Parameter&#8221;. Possible failure reasons: Problems with the<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[88],"tags":[90,8,89],"class_list":["post-325","post","type-post","status-publish","format-standard","hentry","category-microsoft-sql-server-mssql","tag-microsoft-sql-server","tag-microsoft-windows-server","tag-mssql"],"_links":{"self":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/325","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/comments?post=325"}],"version-history":[{"count":1,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/325\/revisions"}],"predecessor-version":[{"id":327,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/posts\/325\/revisions\/327"}],"wp:attachment":[{"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/media?parent=325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/categories?post=325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.amixa.com\/blog\/wp-json\/wp\/v2\/tags?post=325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}