Both the sql server option and hangfire look great. Thanks guys!
On Fri, 4 Jan 2019 at 12:56, Greg Low <[email protected]> wrote: > It's trivial to do directly in SQL Server as well. > > > > Just add a job that starts when Agent starts (there's an option for that), > and which sleeps for 1 minute (WAITFOR DELAY '00:00:01'; ) and checks, > sending an email if a row is present. Have it run forever ie: WHILE 1 = 1 > blah blah > > > > Regards, > > > > Greg > > > > Dr Greg Low > > > > 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 > fax > > SQL Down Under | Web: www.sqldownunder.com |http://greglow.me > > > > *From:* [email protected] <[email protected]> *On > Behalf Of *Tony Wright > *Sent:* Friday, 4 January 2019 12:47 PM > *To:* ozDotNet <[email protected]> > *Subject:* Re: [Possibly OT] Job scheduler from Sql Server > > > > I've also used hangfire and it's a great product. > > > > On Fri., 4 Jan. 2019, 8:20 am Tony McGee <[email protected] wrote: > > I'm not sure if there's anything within SQL Server that does this > specifically. > > > > If you're planning to write some code to achieve it though then I would > recommend first looking into Hangfire (https://www.hangfire.io) to > greatly reduce that burden. > > > > On Fri, 4 Jan 2019, 08:39 Tom P <[email protected] wrote: > > Hi folks > > > > I suspect this may require .NET so asking here for advice. > > > > Say I have a schedules table in Sql server with 2 columns (for > simplicity), name and a cron value. What I wish to build is something which > will send an email whenever it is time based on the schedules table records. > > > > Will this require a .NET windows service for example to poll this table to > take action or is there something already present in Sql server (agent?) > which can do this? > > > > Cheers > > Tom > > > > -- > > Thanks > > Tom > > -- Thanks Tom
