sp_dropwebtask (version 6.5)

Deletes a previously defined web task. The task to be deleted is identified by the output filename, by the procedure name, or by both parameters.

Syntax

sp_dropwebtask {@procname = procname | @outputfile = outputfile | @procname = procname, @outputfile = outputfile}

where

@outputfile

Specifies the name of the web task to be deleted. The outputfile variable is of varchar datatype and has a maximum of 255 characters.

@procname

Specifies the name of the web task procedure to delete. The named procedure describes the query for the web task. The procname variable is of varchar datatype and has a maximum of 28 characters.

Remarks

This stored procedure must be executed in the database specified in the @dbname parameter of sp_makewebtask.

Important The sp_dropwebtask, sp_makewebtask, and sp_runwebtask stored procedures can be run only on Microsoft SQL Server version 6.5 databases. Running these procedures on a database of a previous version will return errors.

For more information about creating and running a web task, see sp_makewebtask and sp_runwebtask later in this document.

Example

This example deletes a web task by using the @outputfile of C:\WEB\MYFILE.HTML and an @procname of MYHTML.

sp_dropwebtask @procname = MYHTML, @outputfile = 'C:\WEB\MYFILE.HTML'
  

Permission

The user deleting the web task must be the owner of the specified procedure.