Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 SQL Server Administration (2005)
 is there a way to quickly test an operator?

Author  Topic 

bugulgad
Starting Member

21 Posts

Posted - 2009-03-03 : 13:40:11
I don't see a way from the operator window that you can send a test email like I could in 2000

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2009-03-03 : 13:41:02
You can send a test email through the Database Mail GUI.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Michael Valentine Jones
Yak DBA Kernel (pronounced Colonel)

7020 Posts

Posted - 2009-03-03 : 14:42:23
I just setup a dummy job, set the operator I want to test as the notification on the job, and execute it.

You could probably create a simple script for this to create and execute the dummy job to make it easier to test.


CODO ERGO SUM
Go to Top of Page

bugulgad
Starting Member

21 Posts

Posted - 2009-03-03 : 15:14:45
I like the idea of a test job. I will use that. Thanks
Go to Top of Page
   

- Advertisement -