Anyone has done this before?

Thanks Doug for your reply.

I've done this trick and only works when you execute Subscription after first one completes. My requiremeent is to execute subscription multiple times on the fly....

Anyone has a workaround on finding out how to alert users on the Data Driven Subscription Completion?

Thank you

Try this one:

Declare @STR varchar(20),@i as int

Set @STR='HELLOW WORLD'

Set @i=1

While @i <= len(@str)

Begin

print left(@str,@i)

Set @i=@i+1

End