Results 1 to 3 of 3

Thread: Alerts

  1. #1
    Join Date
    Dec 1969

    Default Alerts

    How do recruitment sites do job alerts. I mean, when a new vacancy matches certain criteria details are emailed or sent to a mobile...<BR><BR>Do they run a query every hour or so? If so, how do you get SQL to do that...?<BR>

  2. #2
    Join Date
    Dec 1969

    Default RE: Alerts

    1) scheduled tasks from within SQL server <BR><BR>2) write a VBscript file and schedule its execution<BR><BR>

  3. #3
    Join Date
    Dec 1969

    Default Hourly or daily.

    There are a few ways of scheduling jobs. Sql Server has it&#039;s own built-in scheduler (as does Oracle).<BR><BR>There are also external scheduling methods. There was a great article on a while ago. It should give you a good idea of how to go about this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts