July 15, 2008 at 6:05 pm
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
July 15, 2008 at 7:55 pm
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 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy