Home Forums SQL Server 2005 SQL Server 2005 Security Cannot run query as job, but can run it as a query RE: Cannot run query as job, but can run it as a query

  • August 25, 2011 at 7:39 am

    #1373150

    Add @append_query_error = 1 to the call to sp_send_dbmail

    That way an email will be sent with the results of the attempt to run the query.