notification to an application or a 3-party tool

  • In SQL Server, is there a way which SQL Server can pass messages to inform an application or a third-party tool when it finishes some tasks?

  • Sending email at the end of a task is probably the simplest and easiest way to do it. Another technique would be to insert a row into a table or create a file on disk - in both cases you'd poll until you got the result you wanted.

    Andy

  • You could also write an XP dll to do pretty much anything you cannot do directly in SQL in this case (such as sending data to a server using UDP or TCP). The question is what are you trying to accomplish and what are the requirements to meet them?

    "Don't roll your eyes at me. I will tape them in place." (Teacher on Boston Public)

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply