Not so much of a problem as the process I currently have works fine I just would like to improve it by completely automating it. I've done a lot of Google search and couldn't really find anything. I have an app built using Access VBA, that uses an API called esignal desktop api (the api supports only VB and C++). This app allows me to have a live feed to the NYMEX market so that I can get current prices for 60 Natural Gas symbols to populate a table that is then used by another vba access application and also by a web application that we use to generate pricing for our commercial deals. Anyways, I currently have to hit a button on my form first thing in the morning to start the timer which runs the module every 5 minutes which populates a table each time. Then I have to stop it(close the form) whenever the market closes around 3:30. I would like to build a job in sql server that would run the module every 5 minutes on the weekdays but have not been able to find a command in SQL server that would run a module that is in Access or open the form in access which would have its own timer on it. Sorry if this isn't clear enough it's a little tough to explain as I'm pretty new to all this.
Thanks!