Jobsite project - a requirement clarification

Posted by Gayathri under ASP.NET on 2/20/2014 | Points: 10 | Views : 1919 | Status : [Member] | Replies : 2
Hi,
I am building a job site in asp.net 2.0 . I have a requirement like, job seekr will set the alert for a particular skill and he / she need to get an automatic email alert.
can i do this with a webservice.
i have two tables one for job posted
and one for job alert
job posted will have status as active or closed.
job alert matching criteria in job posted will have to send this email.
please guide




Responses

Posted by: Ssnkumar3 on: 2/20/2014 [Member] Starter | Points: 25

Up
0
Down
Hi,

My suggestion is instead of writing web service you can schedule a job in sql server or windows server. Set the schedule time as you wish. Else use Sql trigger to trigger the mail using msdb.dbo.sp_send_dbmail.

Hope this will give some idea or close the issue.

Thanks,
S. Sankar

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Posted by: Gayathri on: 3/3/2014 [Member] Starter | Points: 25

Up
0
Down
Sankar, thanks for your reply and sorry for the delay in response.since I have no experience in windows service or sqlserver job may i please request for an alternate method which can be easily done?

Gayathri, if this helps please login to Mark As Answer. | Alert Moderator

Login to post response