Use the Web Assistant Wizard to build a query, schedule a task, and generate an HTML file. You can add this functionality to your own code by using the sp_makewebtask stored procedure that generates the HTML file. This system stored procedure can be called by a Transact-SQL program. You can also call system stored procedures to run or drop the task.
To call the Web Assistant Wizard from a program, execute sp_makewebtask.To run a Web Assistant Wizard task from a program, execute sp_runwebtask.To drop a Web Assistant Wizard task from a program, execute sp_dropwebtask.