I am using SQL server 2008 Standard edition. I am using Policy based management with policies which come with SQL server during installation.
I want the policies to only look at events that happened in last 24 hours. For example for "Windows Event Log System Failure Error" policy if system restarted unexpectedly 5 days ago, i don't want to be alerted daily.
Is there any way by which I can restrict a policy to look at events which happened in last 24 hours not older?
Any help please?
Thanks in advance.