etbta.blogg.se

Click on OK to come back to your inbox and verify that the error emails have a red font.Ĭreate a Conditional Formatting Rule to Highlight a Failed Job Email in Green After Resolution: If you get emails with different text patterns then you can always create a new rule for each phrase. Now this a simple example with a text phrase for filtering but you can use other criteria in More Choices and Advanced tabs too for more complex scenarios as necessary. My emails have the following text in the email body that I can use for identification – just in the email subject or, email body or both. Also specify in the drop-down where exactly the filter should look for the text phrase i.e.

In the Filter window, put a sufficiently unique text phrase from the error email that can distinguish it from good emails. In the Conditional Formatting window, click on Add and rename the new untitled rule. Then change the font color to red and click on Condition. Right-click on the header row and go to View Settings. You can even customize your main Inbox folder view, if that is where your emails are. Navigate to the folder where you would like to modify the view. The conditional formatting rules highlight the job failure emails with the red color and turn them green when marked complete as shown in the following image.Ĭreate a Conditional Formatting Rule to Highlight a Failed Job Email in Red: In addition to that, I use conditional formatting rules to keep track of action items as pending or done.

I use filter rules in MS Outlook to organize my inbox by redirecting all the scheduled job emails to a separate folder. Some scheduled jobs send failure emails upon an error and DBAs need to remember to fix the job and re-execute it.