Calling a webservice URL from a SQL job or Stored Proc
Posted on 2011-03-08
I need to "execute" a Web Service, URL, for every mlsnum returned by the query below:
where Created_on > 'dec 1 2009'
and (Longitude is null or Latitude is null)
order by Created_on, mlsnum desc
I need a job that calls the following URL with the MLSnum appended to the end.
I don't want to write code, a CLR, etc. or use windows scheduler, etc. mainly because there are other actions that are being undertaken by the same SQL job that I want to do the above. I want the entire process to be database driven.
Thank you in advance.