Sending test emails - SQL Server 2005

• jr-691257

  SSC Journeyman

  Points: 84

  More actions

  July 15, 2008 at 6:05 pm

  #188184

  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?

  Thanks,

  jonathanr

• ksullivan

  SSCrazy

  Points: 2346

  More actions

  July 15, 2008 at 7:55 pm

  #843473

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