CODEWITHSUNDEEP
asp.net-mvcstored-proceduresquartz.net
Sergey Metlov
Sergey Metlov

Reputation: 26291

Every-minute stored procedure executing using Quartz.Net

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.

Upvotes: 1

Views: 1107

Answers (3)

Ryan
Ryan

Reputation: 4313

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());

Upvotes: 1

nickvane
nickvane

Reputation: 2999

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

Upvotes: 1

Darin Dimitrov
Darin Dimitrov

Reputation: 1038820

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?

Upvotes: 2

Related Questions