Microsoft KB Archive/255057

= BUG: Multiple CmdExec Tasks Leave Multiple SQLTASK_*.OUT Files in \Winnt\System32 Folder =

Article ID: 255057

Article Last Modified on 10/3/2003

-

APPLIES TO


 * Microsoft SQL Server 6.5 Standard Edition

-



This article was previously published under Q255057



BUG #: 18992 (SQLBUG_65)



SYMPTOMS
If you run multiple CmdExec tasks that generate output and run concurrently, SQLTASK_xxxxxxxx.out files (where xxxxxxxx is a randomnly generated number) could remain in your \Winnt\System32 folder. SQLTASK_*.out files are created for CmdExec tasks that generate output. SQLTASK_*.out files are temporary files that should be deleted at the completion of a task. In this case, the SQLTASK_*.out files created for one of the tasks is deleted, but the .out file for the other task may not be deleted.

If both tasks are scheduled at one minute intervals, hundreds of .out files could be generated within a few hours. These .out files are deleted when you stop and then restart SQL Executive.



WORKAROUND
Create a scheduled task to run at regular intervals that deletes residual SQLTASK_*.out files from the \Winnt\System32 folder.

Stopping and then restarting SQL Executive deletes the SQLTASK_*.out files.



STATUS
Microsoft has confirmed this to be a problem in SQL Server 6.5.

Keywords: kbbug kbpending KB255057

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.