Post reply

Operator notify task

  • February 22, 2010 at 9:02 am

    #137313

    Hi again

    I have a question about the operator Notify task. in my Dev environment this is set to a particular operator, however when I deploy this I want to be able to set the operator to someone else. Is there a way to add this setting to my SQL package configuration as i can't see one at the moment?

    Thanks

  • February 22, 2010 at 9:12 am

    #1123040

    You can do it with package configurations. Or you can adjust parameters at run-time. The best method depends on how you wil be calling the package.

    CEWII

  • February 22, 2010 at 10:00 am

    #1123099

    Right I have added a variable as a String and added the name of the operator to it.

    I have then tried to add that variable to the notifyoperator expression property, but it doesn;t like it I think because the operator is an Object, but then you can't use obejcts in expressions it seems.

    I am using a SQL Server package config, and I can't see any options in the package configuration that correspond to the operator name.

    I will be calling the package from a job, can you tell me what I would need to do to allow me to set the operator in my config SQL table?

    Many thanks

  • February 22, 2010 at 10:15 am

    #1123109

    I would probably not use that task, I'd probably do it with an EXEC SQL task, since all it really does is:

    EXECUTE msdb.dbo.sp_notify_operator @name=N'operator name',@body=N'the body'

    CEWII

Viewing 4 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply