SQL Server alert

Question

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 1

Yes, you can use the SQL Agent Alerts. Here's an introduction to them in the Books Online.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt

tt-615680 SSCertifiable Points: 7835 More actions · Answer 2

I tried using the following script to set up the SMS for the provider tmobile for example, but it still does not work,

USE [msdb]

GO

EXEC msdb.dbo.sp_send_dbmail

@subject = "Test SMS",

@body = "test sms"

GO

Would you please let me know what is going wrong?

Thank you!

Grant Fritchey SSC Guru Points: 398890 More actions · Answer 3

Not without error messages or something that indicates what's going wrong on your end, no.

"The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
- Theodore Roosevelt