hello, I have a lot of SQL alert where most of the interresting informatrion are not in the notification but only in the alert context tab. Anyway to change this? Most of these alerts are sent by the All Alerts notification. Should I create a specific Notification Subscription to have the description of the notification includes the Alert context? A new notification Channels? Could it be done at the Monitor Description level? Context: Date and Time: 7/6/2011 6:04:27 PM Property Name Property Value {7E2E2AB0-D768-4EA8-86BD-0554F02B19DA}-Duration 0 {7E2E2AB0-D768-4EA8-86BD-0554F02B19DA}-LastStatus 0 {7E2E2AB0-D768-4EA8-86BD-0554F02B19DA}-LastMessage The job failed. The Job was invoked by Schedule 193 (Schedule_1). The last step to run was step 1 (063FFAEE-2D15-48AE-9BB0-20D2ADBC4AB0_step_1). {59CEBFE4-6906-4DFD-A7DB-0617568CBC08}-Duration -1 {59CEBFE4-6906-4DFD-A7DB-0617568CBC08}-LastStatus -1 {59CEBFE4-6906-4DFD-A7DB-0617568CBC08}-LastMessage {DD6FED23-EF24-4A04-BA69-1C47A9DAB018}-Duration -1 {DD6FED23-EF24-4A04-BA69-1C47A9DAB018}-LastStatus -1 {DD6FED23-EF24-4A04-BA69-1C47A9DAB018}-LastMessage {719B8C3E-5F2B-4983-BFB1-37561BE37810}-Duration 0 {719B8C3E-5F2B-4983-BFB1-37561BE37810}-LastStatus 0 {719B8C3E-5F2B-4983-BFB1-37561BE37810}-LastMessage The job failed. The Job was invoked by Schedule 161 (Schedule_1). The last step to run was step 1 (03A95EAE-C67B-4CAA-9568-38E57E87D627_step_1). {012128B8-9610-4583-B249-45F7A65129D8}-Duration 0 {012128B8-9610-4583-B249-45F7A65129D8}-LastStatus 0 {012128B8-9610-4583-B249-45F7A65129D8}-LastMessage The job failed. The Job was invoked by Schedule 180 (Schedule_1). The last step to run was step 1 (FA90F7D8-C6BA-4D16-AEE6-982605623AC6_step_1). {7A024B70-F72E-4AE6-9455-9B7C0E9A33E6}-Duration -1 {7A024B70-F72E-4AE6-9455-9B7C0E9A33E6}-LastStatus -1 {7A024B70-F72E-4AE6-9455-9B7C0E9A33E6}-LastMessage {903A5663-8DAD-494D-9CA2-A1B29ED73C8A}-Duration 0 {903A5663-8DAD-494D-9CA2-A1B29ED73C8A}-LastStatus 0 {903A5663-8DAD-494D-9CA2-A1B29ED73C8A}-LastMessage The job failed. The Job was invoked by Schedule 215 (Schedule_1). The last step to run was step 1 (5D6A0D9E-8666-488D-881B-249116FEF5E4_step_1). {D0F00A57-05C1-4E70-AABA-A307095A5664}-Duration -1 {D0F00A57-05C1-4E70-AABA-A307095A5664}-LastStatus -1 {D0F00A57-05C1-4E70-AABA-A307095A5664}-LastMessage {D4A90CB7-3F38-44BC-8D8D-A926A1D19DE6}-Duration 0 {D4A90CB7-3F38-44BC-8D8D-A926A1D19DE6}-LastStatus 0 {D4A90CB7-3F38-44BC-8D8D-A926A1D19DE6}-LastMessage The job failed. The Job was invoked by Schedule 213 (Schedule_1). The last step to run was step 1 (48DE4D36-BE43-45B2-9A2A-859F691B6D6D_step_1). {ED09913A-E71F-4D47-9B92-B879FBFF8738}-Duration 0 {ED09913A-E71F-4D47-9B92-B879FBFF8738}-LastStatus 0 {ED09913A-E71F-4D47-9B92-B879FBFF8738}-LastMessage The job failed. The Job was invoked by Schedule 211 (Schedule_1). The last step to run was step 1 (901B00FC-B197-4B80-87D5-104C29C06FF7_step_1). {C32E235E-222A-49AE-9224-C0B539C514C8}-Duration 0 {C32E235E-222A-49AE-9224-C0B539C514C8}-LastStatus 0 {C32E235E-222A-49AE-9224-C0B539C514C8}-LastMessage The job failed. The Job was invoked by Schedule 188 (Schedule_1). The last step to run was step 1 (EF1F7485-7A60-4ADC-820E-B396199F163A_step_1). {69E9161F-6C55-4FB8-9268-F57487A9E3ED}-Duration -1 {69E9161F-6C55-4FB8-9268-F57487A9E3ED}-LastStatus -1 {69E9161F-6C55-4FB8-9268-F57487A9E3ED}-LastMessage e.g.:Microsoft.SQLServer.2005.AgentJob.JobLastRunState Monitor: Last Run Status thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager

Hi Dom As these are in sealed management packs (in this case SQL), there is sadly no way to change this. It is the way the pack was authored. You could in theory open the management pack (unseal it) and change the logic but this is not a practical solution as I discuss below: http://systemcentersolutions.wordpress.com/2010/04/14/unsealing-sealed-management-packs/ The only practical solution is to write your own script and disable the out of the box one (even better, get your DBAs to write a script!). Cheers Graham View OpsMgr tips and tricks at http://systemcentersolutions.wordpress.com/

Thanks Graham ... Let me see which script I could use as I saw some post http://www.simple-talk.com/sql/sql-tools/operations-manager-a-big-tinker-set/ but I could not find the script (: and http://systemcentercentral.com/Default.aspx?TabId=143&IndexId=59564 where there is a script. I am trying to get more information in the emails notifications. Thanks, Dom System Center Operations Manager 2007 / System Center Configuration Manager 2007 R2 / Forefront Client Security / Forefront Identity Manager