Hello all,
The current project I'm working on requires me to automate some VB.NET code to run every 24 hours. Currently I have everything tied to a local webpage and I've just been calling it all from a button click in a browser. A normal web app basically.
My question is....what is the best way for me to start getting this to run on a schedule time frame? I've been looking into triggers, but if I'm not mistaken those are supposed to execute when an event is taken on the actual database. No action is taking place, I just need the code to execute. I've executed SQL statements with VBScript and task manager, but I've never had to work with VB.NET and SQL Server (using 2008) in this manner.
Thanks!
The current project I'm working on requires me to automate some VB.NET code to run every 24 hours. Currently I have everything tied to a local webpage and I've just been calling it all from a button click in a browser. A normal web app basically.
My question is....what is the best way for me to start getting this to run on a schedule time frame? I've been looking into triggers, but if I'm not mistaken those are supposed to execute when an event is taken on the actual database. No action is taking place, I just need the code to execute. I've executed SQL statements with VBScript and task manager, but I've never had to work with VB.NET and SQL Server (using 2008) in this manner.
Thanks!
Comment