Home Forums SQL Server 7,2000 T-SQL Create a scheduled task to email from SQL RE: Create a scheduled task to email from SQL

  • Lookup xp_sendmail in BOL. Set @query, @attach_results, and @separator parameters.

    OR

    If you are using 2000 and have Reporting Services you could setup a subscription in RS.