This is kinda hard to explain so here goes. I have a project as follows...
I don't wont a web service or a console service application.
1st interface (SQL Server)
Nightly Load to data warehouse finishes. My new polling trigger kicks in as
follows:
i.) Checks to see if MIS Run has finished successfully.
If YES, goto next job step and trigger a MISRECON Routine. If NO, terminate
program.
ii.) Polls to see if MISRECON has finished successfully.
If YES, goto next step and trigger uspReconciliation. If NO keep polling
until it is. If NEVER, terminate program.
iii.) Poll to see if uspReconciliation is finished successfully.
If YES, goto next step and trigger standard MISRE checks. (these are
maintained daily by users thru dotNet app)
If NO, keep polling until it is, If NEVER, terminate program.
2nd interface (VB.Net)
1. user logs and frmMain opened
2. MultiLine Text Box is blank but will hold logging information later see 3
& 5 below.
3. User presses btnRoutines and uses a checked list view to add/set sProcs
to be run that night based on trigger above.
4. User returns to frmMain and closes app.
5. sProcs run and return @result_text and @result (0 success <> 0 fail) to
dotNet app. These appear in MultiLine Text Box and are automatically logged
to .txt
6. If all succesfull send use .net to send SMS to support cover saying 'stay
in bed'
Due to 5 and 6 I cant think of shutting the application (at least on the
server side)...Can I?
ps: thanks for your help dudes.