Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Sending Multiple Independent Messages to Multiple Users Expand / Collapse
Author
Message
Posted Sunday, May 12, 2013 8:28 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 3:28 AM
Points: 3, Visits: 2
I have confusion regarding how to send multiple messages to multiple users at the same time at periodic intervals(weekly basis or monthly basis)
i.e each user will get different message... please suggest any solution
Post #1451906
Posted Sunday, May 12, 2013 1:37 PM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 4:45 PM
Points: 709, Visits: 4,525
not much to go on...

what kind of message? Based on what? Service Broker might be a solution.
Post #1451928
Posted Sunday, May 12, 2013 11:58 PM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, December 10, 2013 3:28 AM
Points: 3, Visits: 2
I Need to send job alerts on weekly basis. so each person will get different Matched job results i.e. based on employer job postings , weekly matched job alerts will be given to job seekers. Each job seeker will get different job alert. I need to send this job alert to all jobseekers automatically at the same time. So how can I achieve this in sql server
Post #1451978
Posted Tuesday, May 14, 2013 10:55 AM
Say Hey Kid

Say Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey KidSay Hey Kid

Group: General Forum Members
Last Login: Today @ 4:45 PM
Points: 709, Visits: 4,525
probably sp_sendDBMail and jobs. Definitely not triggers.
Post #1452725
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse