Powershell scripts
any 1 has script following job on sql servers:
1. powershell script check free space on drives, if 10% free, send email adminstrator
2. script keep track disks spaces, save table, then schedule run every month, later analysis of growth?
thanks
sqlfriend
you can set scheduled task run want, @ last job, used script, ran once day. if that, html file sent, has the date when ran in name of file itself, should named diskspcae_20121207.html. if going run multiple times, , want include timestamp can modify line # 33, format date see fit.
as excluding drive, have on script again , let know, may simple where-object clause exclude s: drive, not sure @ time.
if find post has answered question, please mark answer. if find post helpful in anyway, please click vote helpful.
Windows Server > Windows PowerShell
Comments
Post a Comment