Every-minute stored procedure executing using Quartz.Net

Question

I want to implement every-minute database stored procedure executing in ASP.NET MVC web site using Quartz.Net. I wonder how can I exec the procedure with and without parameters.

score 2 · Accepted Answer · edited May 23 '17 at 11:47

2

Well, it's a matter of configuring the scheduler and then in the job implementation call the stored procedure. Also if you are using SQL Server haven't you considered doing this using the server agent?

edited May 23 '17 at 11:47

Community

1
1

answered May 17 '11 at 16:34

Darin Dimitrov

1,023,142
271
3,287
2,928

I have no ability to use SQL Server Agent, that is why I have to use Quartz. – Sergey Metlov May 17 '11 at 17:55

score 1 · Answer 2 · edited May 23 '17 at 11:47

1

See How to use Quartz.net with ASP.NET for implementing Quartz in asp.net

edited May 23 '17 at 11:47

Community

1
1

answered May 17 '11 at 16:51

nickvane

2,979
2
20
23

score 1 · Answer 3 · answered May 18 '11 at 02:56

1

It would be easier to use Reactive.NET and drop it in a Windows service (it takes just a few minutes with Topshelf).

Observable
    .Interval(TimeSpan.FromMinutes(1))
    .Subscribe(i => ExecuteStoredProc());

answered May 18 '11 at 02:56

Ryan

4,303
3
24
24

Every-minute stored procedure executing using Quartz.Net

3 Answers3