Hi... pls help me
thanks for advance
my requirementi is
table--->subcomment
Field--->Followupdate
Output-->Sms
-------------
step1: check in subcomment table,whether any of the FollowupDate(column name) is today date
step:2 If it is todays date,check whether time is exactly less than 60mins of current time
step:3 if step2 is true, fetch the subid,followupdate,comments and find the createdby by using join of dcrno in subcriber table and subid in subcomment table
step:4
Find the phone num of this 'createdby' user in Employee table +Login User Table
step:5
send sms to this phoneno with details like
custname,ph,subid-->subscriberdetails
followdate ,comments--->subcomment