Executing a stored procedure every hour by using the .net code

Question

How can I execute a stored procedure every one hour by using .net code?

(Stored procedure should be executed automatically for every one hr)

Is there a reason you can't use a SQL job? If not, you probably want a service rather than a .NET app - since a service will be automatically started on startup and will be transparent to the user — Charleh, Jul 09 '12 at 13:13
You could just use and app and use the windows scheduler to run it every hour. Or sql server jog as recommeneded above. — paparazzo, Jul 09 '12 at 13:18
@All, Am ready to use .net or sql code to complete this task. Thank You. — Software Enginner, Jul 09 '12 at 13:22
Duplicate of http://stackoverflow.com/questions/2342935/how-to-schedule-a-stored-procedure — STW, Jul 09 '12 at 14:16

score 6 · Accepted Answer · answered Jul 09 '12 at 13:20

6

.net processes are too expensive in terms of memory for such tasks.

If you really need to run a .net application, look out for scheduled tasks. Windows task scheduler is good for such tasks.

answered Jul 09 '12 at 13:20

nunespascal

score 1 · Answer 2 · edited May 23 '17 at 12:06

1

First you need to write a Windows service and set it to run every hour.

Calling a stored procedure from c# code can be done Like this.

I haven't posted any code myself becuase I can't find any code in your question as well. A little effort will get you a long way

edited May 23 '17 at 12:06

Community

answered Jul 09 '12 at 13:14

score 1 · Answer 3 · answered Jul 09 '12 at 13:34

As commented, best option is to create an SQL agent job. From Microsoft MSDN, to create a SQL Server Agent job:

3 Answers3