When we first installed the Altiris Helpdesk solution we created a number of notifications to help enforce SLAs. Though this is a very useful feature of the helpdesk system, it makes for a lot of messages in your inbox every Monday.
We started looking for a way to limit the policies only to run on certain days of the week, but the shared schedules in the notification server don't allow for running on only specified days of the week. Instead, we solved the problem by making a simple modification to the WHERE clause in the SQL that controls the notification.
AND DATENAME(dw,GETDATE()) IN ('MONDAY','TUESDAY','WEDNESDAY', 'THURSDAY', 'FRIDAY')
If you haven't modified the SQL in these policies before here is a quick rundown of how to do it.
- Navigate to the notification policy you want to edit.
- Click 'Edit Query'.
- Add in the SQL above.
- Click Finish and save the policy.
Now this policy will only return data if the day it is run on matches what you specified. The days can be replaced as a parameter in your policy (as it was in the example), which makes it very easy to work with. You simply type in the days of the week when you want the policy to return data and on the other days you will not get extra notifications.