Sending test emails - SQL Server 2005

  • Hi,

    I am setting up notifications in SQL Server 2005 that will be triggered if a job fails. I want to test that these emails will be sent (and received) but I am not sure where I test this from. In SQL Server 2000 there is a 'Test' button which makes the job easy but I cannot see the same option in 2005. Also in 2000 you can nominate the mail profile that is to be used by the SQL Server Agent, where is this set in 2005? - can anyone assist?



  • Simple workaround for testing is to make a job step that deliberately fails and run it. Something like select 1 from ThisDoesNotExist

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply