If you have a requirement to cleanup older than 30 (or any number of days), days of folders and files from any designated location, you can do it via SQL Server Agent Job.
Just setup the job with Type as "PowerShell" and paste my code.
Configure and run it.
Ensure that you have powershell 2.0 configured.
Get-ChildItem "D:\backups\" -force -recurse | where-object {$_.LastWriteTime -le (Get-Date).AddDays(-30) -and !$_.PsIsContainer} | remove-item -force; 
If you have a requirement to send email to recipients with attachment, can use the script.
2019-05-03 (first published: 2016-05-17)
3,100 reads
Creates a record of all or part of a Windows PowerShell session in a text file.
2019-05-03 (first published: 2015-09-17)
1,112 reads
2019-05-03 (first published: 2015-03-29)
1,737 reads
Check all the running SQL services in different servers.
You can use the details before you start implementing SQL Patch to the servers i.e. if you want to explicitly stop the SQL Services.
2019-05-03 (first published: 2015-03-26)
2,055 reads
Execute the function and pass only the SQL Server Name to check if the SQL Instance is available and if yes, what is the Instance Type.
2019-05-03 (first published: 2015-03-26)
1,279 reads