Click here to Skip to main content
15,891,607 members
Please Sign up or sign in to vote.
2.00/5 (1 vote)
See more:
SQL
MY DATA BASE ALERT TABLE 

I NEED TO SEND AN ALERT VIA MAIL AND SMS


ColumnNmae    Datatype 

A_ID	       int

TIME_STAMP     datetime

MOBILE_NO	text	

EMAIL_ID	text	

SMS	     nvarchar(MAX)	

STATUS_ID	int	

SUBJECT	     nvarchar(MAX)	

BODY	     nvarchar(MAX)

PROCESS_ID	int	

PROCESS_NAME	nvarchar(50)	

PRIORITY	nvarchar(50)	


sample data:-

A_ID TIME_STAMP MOBILE_NO EMAIL_ID SMS STATUS_ID

1 2/28/2012 12:00:00 AM 999999999 k@yahoo.com hi 1

SUBJECT BODY PROCESS_ID PROCESS_NAME PRIORITY
alarm hiii 1 alert high

_______________________________________________________________________________

A_ID TIME_STAMP MOBILE_NO EMAIL_ID SMS STATUS_ID

1 2/29/2012 1:00:00 AM 1234567899 k1@yahoo.com HELO 0

SUBJECT BODY PROCESS_ID PROCESS_NAME PRIORITY
alarm hiii 1 alert MEDIUM
Posted
Updated 11-Mar-12 19:54pm
v3
Comments
CRDave1988 12-Mar-12 1:33am    
What IS Your Problem?
Prasad_Kulkarni 12-Mar-12 1:33am    
what is this?
format your code,is really hard understand this.

No one is going to give you any code.
Here is a set of guidelines that should help you ask a better question - Some guidelines for posting questions in the forums[^].
 
Share this answer
 
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900