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 2000 Forums
 Import/Export (DTS) and Replication (2000)
 Sending Notification From DTS

Author  Topic 

ramdas
Posting Yak Master

181 Posts

Posted - 2003-02-20 : 15:16:33
Hi Folks,
I have a DTS package which sends out E-mail once the package is Complete. I would like to have the message sent to a Pager. Is there a way to do it.

Thanks
Bye


Ramdas Narayanan
SQL Server DBA

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-02-20 : 15:24:51
Can your pager accept e-mails? That's how we do it here. We just e-mail the status of a job to an e-mail address which happens to be a pager.

Go to Top of Page

ramdas
Posting Yak Master

181 Posts

Posted - 2003-02-20 : 17:20:47
Thanks for your reply. To answer your question: The pager can accept e-mails.
Bye

Ramdas Narayanan
SQL Server DBA
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2003-02-20 : 17:26:59
Then use the e-mail address of your pager in the E-mail task for DTS. Just keep the e-mail very short so that you don't get multiple pages. We currently have our Log Shipping jobs e-mail us on failure (not through DTS though). Because the failure e-mail isn't, it comes across in two pages. This can be very annoying at times.

Go to Top of Page
   

- Advertisement -