[quoted text, click to view] Zac Maclean wrote:
> Looking for some pointers, tutorials, online help to get me going.
>
> I need to write a service that monitors a SQL server agent (replication) and
> will run basically a macro in an Office program to update certain files
> maintained in the DB.
> Basic flow:
>
> User fires replication event, updating up to 50 records.
> If certail record criteria are met, service initiates an Office macro that
> updates the files (no other way I can find to do this part)
> Service drops back to monitoring.
>
>
> I may have up to 10 people updating a day, mostly at different times. If
> this is impossible (or even "extremely difficult") I can skip it.
> I have moderate experience programming and fully understand OOP, just not
> used to breaking it down completely.
>
>
> TIA
> Z
Not impossible. My experience automating Office has been slightly
problematic, in the area of errors. Sometimes it wants to throw up a
message box which is detrimental to services.
Otherwise, in general I tend to strive to avoid polling. If you can
trigger your activity to fire a SQL SP or SQL XSP, your system will
behave better. But polling can be done.
Do the best job of Try-Catch protecting everything, and log all
unexpected issues, is my advice.
If this is your first service project, then the learning curve will hit
you, but for anyone writing services often, this sounds minor.
Good luck on your project.
