> I have a VB App that acts as a maintenance of a number of routines to be set
> up, edited and run on a SQL Server Db.
>
> The nature of this app is to return results from the routines(sProcs) and
> pump out a log file with the results from the .net App. A SMS is also sent to
> a support mobile phone to tell on cover staff to come in or out depending on
> the results of these routines.
>
> I cannot kick off the selected routines until a large DTS routin is run.
> This routine runs for about 5-6 hours and it is quite easy to determine when
> it has completed.
>
> My issue is:
> Should I poll/trigger when the DTS is complete from SQLServer or from my
> Vb.net App? (I have no preference at the moment - although the fact I'm
> writing this on a dotnet forum is testament that I am more a .net man than
> Sql man!).
> Whether I poll from SQL or from .net App, i MUST keep the .net App open for
> the duration of the poll in order to send the SMS and create the log. Am I
> thinking the right way about this or what are the alternatives?
>
> I could have written this App completely in SQL but I wouldn't have had the
> safety of a desktop app and various levels of security I can manage from .net
> nor the ability to manage/maintain the types of log and SMS functionality I
> want.
>
> Any input much onliged...
>
> marc
> 
>