Try taking a look at sp_makewebtask in BOL.

I have used the following example in an application that creates a small text file when data changes from a trigger.

sp_makewebtask @outputfile =...