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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 9:23 AM
Points: 571, Visits: 3,739
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
Mr or Mrs. 500

Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500Mr or Mrs. 500

Group: General Forum Members
Last Login: Today @ 9:23 AM
Points: 571, Visits: 3,739
probably sp_sendDBMail and jobs. Definitely not triggers.
Post #1452725
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse