So, I have a DTS package that runs every hour on the hour and checks to see if there has been a certain kind of activity in the last hour, if there hasn't been, it sends an email with xp_sendmail. However, I would like to have it instead send an SMS message, bt I cannot figure out how to do that. I know that I can have it send an SMS message on failure or completion, but that is not what I am looking for, I want it dependent on conditions of the query. Doews anybody out there know if I can in fact get SQL Server to do this? I'm running SQL2K Enterprise on a Win2K3 Enterprise Server.
WB
WB