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
