Schedule Powershell Script

1. Write your PowerShell Script (Myscript.ps1)
2. Save it to a location
3. Go into Windows Sheduler and shedule your script

In Task Scheduler put in program/script: powershell (C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe)
And in arguments -Command "<path to .ps1 script>"
(-Command "C:\Powershell\Testing.ps1")
If you don't want change current execution policy permanently then use -ExecutionPolicy Bypass
All will look like this: powershell -Command "<path to .ps1 script>" -ExecutionPolicy Bypass

SharePoint 2010: Usage files are not deleted, causing timer service problems

The .usage logs are never deleted. There should typically be no more than 6 .usage files at any given time, but when you have this problem, you may find hundreds or thousands of usage logs in the logging directory.

You'll see errors like this in the SharePoint ULS logs when the Usage Import timer job runs:


OWSTIMER.EXE (0x51A0) 0x59E4 SharePoint Foundation Usage Infrastructure a5rv High Failed to delete usage log file 'E:\Logs\ServerName-20130701-2117.usage' after data import. Exception: System.IO.IOException: The process cannot access the file because it is being used by another process. at System.IO.__Error.WinIOError(Int32 errorCode, String maybeFullPath) at System.IO.FileInfo.MoveTo(String destFileName) at Microsoft.SharePoint.Administration.SPProvisioningAssistant.MoveFileOrDirectory(FileSystemInfo fi, String newPath) at Microsoft.SharePoint.Administration.SPProvisioningAssistant.DeleteFileOrDirectory(FileSystemInfo fi) at Microsoft.SharePoint.Administration.SPUsageLogImporter.ImportUsageLogFiles(List`1 usageLogFileList)

This happens when Windows updates KB 2775511 or KB 2682011 or KB 2882822 are applied to the SharePoint servers.

The fix is in the December 2013 Cumulative Update for SharePoint 2010.  

If you look at the description for the Foundation package (which is included in the SharePoint server package) here: http://support.microsoft.com/kb/2849981, you will see this description for one of the issues that are fixed:

"After you install hotfix 2775511 or hotfix 2682011 on a SharePoint Server 2010 server, the Usage Provider (.usage) files are not deleted from the file system. Additionally, the .usage files keep growing."

This is a somewhat generic summarization of the problem that does not include all the known symptoms, but it does fix the issues described in this KB.

Here is the link to the KB and download:
http://support.microsoft.com/kb/2849971

In case you cannot quickly install the December 2013 Cumulative Update, there are two independent workarounds that should get you by until you can:
Set up a scheduled task to manually recycle the timer service (at least) once a day -- every 6 hours would be better.  You can use a PowerShell command like this to recycle the service:  

restart-service -Name SPTimerV4

Then you just need to set up a scheduled task to run it every 6 hours on every SharePoint server in the farm.  When the timer service is manually recycled, the open handles to the .usage files are released, and they will be automatically deleted when the next instance of the Usage Data Import timer job runs (by default every 30 minutes).  There should be no need to manually delete the files.