• actually i am quite new on this powershell scripting, it seems quite complex on this stage. so i have got following script and modified in my ways replaced hours in place of days. when i executed the same it gave me some } error.

    DECLARE @pscmd varchar(1000)

    DECLARE @targetpath varchar(8000)

    DECLARE @olddays int

    DECLARE @extension varchar(5)

    DECLARE @cmdstring varchar(1000)

    --assigning value to parameters, you can customize as per your need

    SET @targetpath = 'D:\Dtest\'

    SET @olddays = -6 --pass the Hours with negative values

    SET @extension = 'txt'

    SET @pscmd = '"& '+

    'Get-ChildItem ' + Quotename(@targetpath,'''') + ' | '+

    'where {$_.lastWriteTime -lt ((Get-Date).AddHours('+ CAST(@olddays as varchar) +'))

    -and ($_.Extension -match ' + QUOTENAME(@extension,'''')+ ') } | ' +

    'Remove-Item -force " '

    SET @cmdstring = ' ""powershell.exe" '+ @pscmd

    exec master..xp_cmdshell @cmdstring