Data Driven Subscriptions

  • Hi guys

    Have this procedure running now, thanks to your help, but I do still have one problem with it:

    If I set the waitfordelay to anything less than 15 seconds the job stops and I get the following error :

    Msg 22022, Level 16, State 1, Line 0

    SQLServerAgent Error: Request to run job 06488FEA-8C35-4844-8FB1-C66242DA6CBD (from User blip\me) refused because the job already has a pending request from User blip\me.

    Has anyone come up with any other way of pausing each job until the last is completed?

  • Thank you so much for this article.

    I was just wondering if anyone else receives this message on execution:

    Error: Deletion length 4 is not in the range of available text, ntext, or image data. (State:37000, Native Code: 1BDF)

    Any advice would be appreciated.


  • I keep getting this error "Deletion length 23 is not in the range of available text, ntext, or image data" inconsistently when this scripts run. It is failing on the replacement of the Email address to the value |TO|.

    -- set the start position for the TO Address

    SELECT @TOpos = patindex('%' + @TO + '%', ExtensionSettings) - 1

    FROM Subscriptions WHERE SubscriptionID = @subscriptionID

    SELECT @length = len(@TO)

    IF @length > 0

    -- replace the addresses with the original |TO|

    UPDATETEXT Subscriptions.ExtensionSettings





Viewing 3 posts - 46 through 47 (of 47 total)

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