Powershell script that will alert me when a certain windows event occurs

RayPaks 31 Reputation points
2022-10-05T06:12:36.863+00:00

Hi. I've been trying to get this working but I've seemed to have hit a brick wall.

Trying to figure out a way to establish an email alert that will let me know when a certain Windows EventID happens.

Preferably I want this set up in SQL server as a job because you can access the powershell subsystem in the job steps, and set a job schedule therein but I'm open to having it set up any other way

I've seen a couple of posts on some forums that were helpful but not helpful enough for me to get this over the line.
A number of them use powershell and then Task scheduler to run a task, this link was helpful and I followed the steps but it is still not working:

https://www.sqlservercentral.com/blogs/step-by-step-how-to-trigger-an-email-alert-from-a-windows-event-that-includes-the-event-details-using-windows-server-2016

Please let me know

SQL Server
SQL Server
A family of Microsoft relational database management and analysis systems for e-commerce, line-of-business, and data warehousing solutions.
12,903 questions
Windows Server PowerShell
Windows Server PowerShell
Windows Server: A family of Microsoft server operating systems that support enterprise-level management, data storage, applications, and communications.PowerShell: A family of Microsoft task automation and configuration management frameworks consisting of a command-line shell and associated scripting language.
5,407 questions
{count} votes