Automating a process

Question

0.00/5 (No votes)

See more:

Hi

I currently have a process when a user clicks a button on the page the program fetches a file from via Ftp and then reads the file and inserts the data into a database table.

I would like to know how would I be able to let this process run automatically at a certain hour? lets say 12:05am daily

Posted 9-Dec-12 20:22pm

isi19

Add a Solution

Comments

AnkitGoel.com 10-Dec-12 4:45am

you have to write a job in sql server which calls a stored procedure and that stored procedure should download the file from ftp and insert the contents into database.

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2012-12-10T18:45:00

Solution 2

You can create a scheduled task by using the CSTaskScheduler task[^].

Posted 10-Dec-12 18:45pm

Abhinav S

Comments

Sergey Alexandrovich Kryukov 11-Dec-12 0:47am

Yes, a 5.
--SA

Abhinav S 11-Dec-12 0:52am

Thank you SA.

Sergey Alexandrovich Kryukov · Answer 2 · 2012-12-10T18:38:00

You can use the Windows Service which is designed for similar purposes and bundled with Windows; you can use it on different levels. It is called Window Task Scheduler, see http://en.wikipedia.org/wiki/Windows_Task_Scheduler[^].

First, you can schedule events using command-line utilities AT.EXE or CSHTASKS.EXE (which is replacing AT.EXE), see:
http://en.wikipedia.org/wiki/At_%28Windows%29[^],
http://en.wikipedia.org/wiki/Schtasks[^],
http://technet.microsoft.com/en-us/library/bb490866.aspx[^],
http://msdn.microsoft.com/en-us/library/windows/desktop/bb736357%28v=vs.85%29.aspx[^].

And you also can use Window Task Scheduler API, please see:
http://msdn.microsoft.com/en-us/library/windows/desktop/aa383614%28v=vs.85%29.aspx[^],
http://msdn.microsoft.com/en-us/library/windows/desktop/aa383608%28v=vs.85%29.aspx[^].

To see how can you use it with .NET, see this CodeProject article: A New Task Scheduler Class Library for .NET[^].

—SA