Jon Skeet [C# MVP] wrote:
RSH wrote:
I have an application that creates an Access version of a SQL Server
database and then it moves the resulting database to an ftp server for the
client to download and run reports against etc. The application is dynamic
in nature and requires user input, but the point is that it isn't a one off
application. I would like to be able to modify the application to receive
the params via the commandline and somehow run automatically off of a set
schedule. Basically I would like it to run unattended twice a day at say
10am and 10pm.
I am familiar with SQL Jobs and schedules but unfortunately I am having to
use .Net for many other reasons so I can't reproduce the application in SQL
so I need some other way of running off a schedule. What are my options?
Where can I find any simple tutorials?
The easiest thing to do is make it a Scheduled Task in Windows. Go to
Control Panel, Scheduled Tasks, and add a new Scheduled Task.
Jon
I second Jon's idea. I did this for *exactly* the same purpose. Just
to give you an idea of what I did.
I created two applications, a console app and a winapp. the winapp was
used by the user and created as "output" a configuration file (I had a
serializable config object). The console app ran using Scheduled Tasks
in windows and took 1 parameter-- the path to the config file. I think
(I no longer have the source) I used a .bat file to "attach" the config
file path, but I don't remember.
As far as I know, this worked great for me, since the customer never
complained.
Scott