Data Driven Subscriptions

• ldanks

  SSChasing Mays

  Points: 660

  More actions

  April 29, 2014 at 6:34 am

  #1709414

  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?

• justGoogleIT

  Grasshopper

  Points: 13

  More actions

  May 9, 2014 at 12:24 am

  #1712051

  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.

  Thanks

• wolfe.steve

  Newbie

  Points: 9

  More actions

  March 19, 2015 at 9:55 am

  #1785125

  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

  @ptrval

  @TOpos

  @length

  '|TO|'