Loading

Send SMS in SQL through trigger

Send SMS in SQL through trigger

Basit Khan

11y3.1kSQL

Dear,

I have created a trigger for sending sms through SQL, But how to put httpget in SQL please help me on this.

Below is the trigger. Note that java script code working fine.

alter TRIGGER CallInserted

ON [dbo].[CustomerCall]

FOR INSERT

AS

BEGIN

SET NOCOUNT ON;

IF EXISTS (SELECT * FROM inserted)

BEGIN

//below is javascript code working fine, But i want to use in SQL

function httpGet(theUrl)

{

var xmlHttp = new XMLHttpRequest();

xmlHttp.open( "GET", theUrl, false ); // false for synchronous request

xmlHttp.send( null );

return xmlHttp.responseText;

}

END

END

GO

Thanks

Basit.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sumit Joshi11y ago
Hi Basit

below is a link thet solves your problem of SMS from SQL

http://stackoverflow.com/questions/10088230/send-sms-using-triggers-and-stored-procedures-from-sql-server-2008

If helpful mark as Correct answer
0
Manas Mohapatra11y ago
See below Trigger how to send e-mail in sqlserver:

CREATE TRIGGER dbo.CallInserted
ON dbo.wherever
FOR INSERT
AS
BEGIN
SET NOCOUNT ON;
   IF EXISTS (SELECT 1 FROM inserted)
   BEGIN
      EXEC msdb.dbo.sp_send_dbmail
      @recipients = '[email protected]',
      @profile_name = 'default',
      @subject = 'Someone was speeding',
      @body = 'Yep, they sure were.';
   END
END
GO

Here need to configure recipients, profile, subjects as per your need. See below link it can be configured easily.

http://solutioncenter.apexsql.com/get-an-alert-when-a-certain-record-changes/

http://www.codeproject.com/Articles/485124/Configuring-Database-Mail-in-SQL-Server
0