Re: [Possibly OT] Job scheduler from Sql Server
Both the sql server option and hangfire look great. Thanks guys! On Fri, 4 Jan 2019 at 12:56, Greg Low 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:* ozdotnet-boun...@ozdotnet.com *On > Behalf Of *Tony Wright > *Sent:* Friday, 4 January 2019 12:47 PM > *To:* ozDotNet > *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 > 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 > 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
RE: [Possibly OT] Job scheduler from Sql Server
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:* ozdotnet-boun...@ozdotnet.com *On Behalf Of *Tony Wright *Sent:* Friday, 4 January 2019 12:47 PM *To:* ozDotNet *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 https://www.hangfire.io) to greatly reduce that burden. On Fri, 4 Jan 2019, 08:39 Tom P
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 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 >> 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 >> >
Re: [Possibly OT] Job scheduler from Sql Server
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 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 >
[Possibly OT] Job scheduler from Sql Server
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
