Post reply

delete txt files created by SQL Job using xp_delete_file with SP3

  • May 1, 2009 at 3:46 am

    #384484

    Hi,

    I am trying to use the code below to delete log files that have been created by some of my jobs, But it does not work! I know there was a bug with this in SP2 but my server is SP3 so the bug should be fixed in this.

    EXECUTE master.dbo.xp_delete_file 1,N'U:\DBA\ERRORLOG',N'txt',N'2009-04-10T10:24:09'

    This server is a 2 node cluster on winNT server SP2.

    The above statement works on my other server which is a standalone with SQL 2005 SP3 (winNT server sp1) so i dont know why its not working on this server.

    please help...

  • May 12, 2009 at 10:19 am

    #993105

    Just had a similar thing happen, in the windows logs we saw that xp_star90.dll caused a win32 error. From that time on the xp_delete_file would not work, or complete in query analyzer.

    To correct the “issue” we ran the move group utility in cluster administrator. But, we are not sure if this corrected the issue on the first node.

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply