Error with simple maintenance plan

Team;

I've been getting nothing but errors recently; as I've been usign
maintenance plans.

Here is one of the error logs.

Executing the query "EXECUTE master.dbo.xp_delete_file
0,N'',N'',N'2008-03-14T00:56:18'
" 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.

I really haven't done anything too fishy with this maint plan; I've
been kinda strugging with these maint plan-- I mean it should be
_EASY_ to setup, right?

I just basically.. have a db that I want to run maint plan on; and
take a backup.
I don't have enough room to store more than 2 backups.

So I told the main plan to clean up BAK files that are more than 8
days old.

Don't make me write a vbScript to do this!
.

Relevant Pages

  • Re: Precompiled statement?
    ... compiles/creates a plan for executing what the SQL wants. ... No need to check before choosing prepared statement, ...
    (comp.lang.java.databases)
  • Re: DB Maintenance Plan Problems
    ... The jobs have all the information for executing the sqlmaint tasks; ... they will also refer to a plan name. ... same databases exist on the other server, you most certainly do not have the ... The job was created but executing seems not to work. ...
    (microsoft.public.sqlserver.programming)
  • Re: DB Maintenance Plan Problems
    ... The jobs have all the information for executing the sqlmaint tasks; ... they will also refer to a plan name. ... same databases exist on the other server, you most certainly do not have the ... The job was created but executing seems not to work. ...
    (microsoft.public.sqlserver.server)
  • Re: How to find query plan for a stored procedure using temporary tables
    ... You get these errors because SET SHOWPLAN_TEXT ON tells SQL Server to ... generate a plan INSTEAD OF executing the SQL. ... at the start of your procs instead of using INSERT INTO. ...
    (comp.databases.ms-sqlserver)
  • Re: Why is this
    ... would be to have a single index on (lastrecon, acctnum, deposit) [or ... cover the query and handle the restrictive condition immediately. ... there is no perfect query plan. ... use the index for TOP 1, even if it used quite a few bookmark lookups, ...
    (microsoft.public.sqlserver.server)