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 >
