search

reubensultana / SQLMonitor

SQL Server monitoring tool based on PowerShell v3 and TSQL scripts only
MIT License
13 stars 8 forks source link

Replace Power shell with SQL Agent Jobs #1

Open durgaganeshpolisetti opened 4 years ago

durgaganeshpolisetti commented 4 years ago

Is it possible to you to convert power shell scripts run through SQL agent using DBmail or add a secure string to existing SMTP config.

reubensultana commented 4 years ago

Hey @durgaganeshpolisetti You can definitely call the PoSh scripts from within SQL Agent however you'd have to set up an account with permissions to execute the .PS1 files, set it up as a Login, a Credential, and with permisions to run PowerShell in SQL Agent. The same account would require Write permissions on the repository database as well as sysadmin permissions on the environments being monitored. I have no immediate plans to develop this project further, at least for the next few months, however feel free to fork it out, make any amendments, and get back to me. I will review the changes and consider them for inclusion in the next version of repository. Thank you for using SQL Monitor. Reuben