Using scheduled exe to send email on server
Posted on 2005-04-25
I have an asp page which loops thru my database and sends out emails. I need this to be scheduled everyday.
Unfortunately this will not be hosted on my server and so are limited in regards to installing components or updates. Fortunately they are using windows 2003 server so I should have a few more options - right?
Anyway the crux is this. They don't want to schedule anything but an exe. Originally I told them to schedule a direct call with IE to the asp page using just the built in windows scheduled tasks but they weren't happy with that, then I supplied to them a vbs file which calls a bat file as explained in "4guysfromrolla.com" and "asp101.com" but they had issues with the XMLHTTP object.
So my question is how would get this into an exe. Would it be possible not to have a separate asp page and have all the code, or similar, within said asp page in the exe? Is it hard to write exe like this and could I do this with just a text editor. If I could get some examples or tutes, that would be great. This has been going on for a while now and would love to just give them what they want and be done with it
We are using MS SQL as the db and I think a SQL agent job could be out too :)
They will still schedule the exe using the windows scheduled tasks
Many thanks in advance!