I've been tasked with coming up with a way to query our RS6000 and using the results to update records in the SQL Server 2005 db. Our RS6000 vendor has created an xml query which we call from an url. We query a table, loop through the results and call the xml query for each record. Then we check for a certain status in the xml results and, if we find it, update the db record. My question is which route would be better; building a web service in .Net or running a vb script from the SQL Server Agent? I normally do such things from a Web Service or an .exe setup under scheduled tasks on the server, but someone suggested SQL job agent route and I was wondering which would be more effiecient?Thanks in advance.
View Complete Post