Sending Multiple Independent Messages to Multiple Users

  • 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

  • not much to go on...

    what kind of message? Based on what? Service Broker might be a solution.

  • 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

  • probably sp_sendDBMail and jobs. Definitely not triggers.

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

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