Scheduled running of a C# application

[RSH]

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?

Thank you for your time,
Ron

 

[Jon Skeet [C# MVP]]

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

 

[John Vottero]

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?

It sounds like the free developers edition of JAMS will satisfy your needs.

JAMS is an enterprise grade task scheduler based on the .NET Framework. You
can get more information and/or download the developers edition from:

http://www.mvpsi.com

John Vottero
JAMS Technical Support

 

[Scott C]

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

 

[Willy Denoyette [MVP]]

| 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

Running a task twice a day can be problematic if not every 12 hour.
This isn't a problem here as the OP want's the task to run at 10am and 10pm,
so he can schedule the task to run evry 12 hours.

Willy.