Notify Operator Task - Unable to set "Notification Message Subject"
-
I normally write scripts to do backups with but have recently had to create some maintenance plans to do backups. No problems there except for notifications using the "Notify Operator Task".
My problem is that, despite what Books Online says, I'm not able to set the "Notification Message Subject" while editing either a new or existing "Notify Operator Task". As you can see in the graphic below, it's grayed-out and not editable. What am I doing incorrectly or is it simply a "bug" that I'm going to need to make a work-around for?
To confirm, I'm using SQL Server 2005 Enterprise Edition.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
I've not been able to find a solution for this other than someone saying that the problem doesn't occur if you use the deprecated SysMail. I guess the work around of using an "Execute SQL Task" with a call to the underlying stored procedure for the "Notify Operator Task" will have to do.
Thanks to all of those who had a look even if an answer wasn't found.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Jeff, I just saw this. Are you sure the issue isn't your connection? I see it set to Local. What happens if you set it to an actual server name? Does it clear the grayed out box?
-
You know... that's probably the only thing I haven't tried. I'll give it a whirl when I get back to work tomorrow. Thanks, Brandie.
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Crud... I know what the problem is. Some folks at work decided that were going to use the 2008 client tools (including SSMS) on a 2k5 database. The "Notification Message Subject" box doesn't even show up in the "Notify Operator Task" in the 2k5 version of SSMS.
That's we get for when someone tries to trick "Mother Nature". Heh... in cases like this, I wish I were still a contractor so I could charge them for the overtime this cost me. :Whistling:
--Jeff Moden
RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
First step towards the paradigm shift of writing Set Based code:
________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.Change is inevitable... Change for the better is not.
Helpful Links:
How to post code problems
How to Post Performance Problems
Create a Tally Function (fnTally) -
Surely you can charge it to another department's cost center? @=)
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply