locked
schedule job to update database each day RRS feed

  • Question

  • User-1715638843 posted

    what is the best and easiest method to update database everyday by fetching results from a 3 rd party api?can i do it like scheduling the job.please give any examples.

    Any help will be appreciated

    Tuesday, October 30, 2018 8:03 AM

Answers

All replies

  • User-821857111 posted

    You can use a scheduling application like HangFire or Quartz.NET (https://www.mikesdotnetting.com/article/254/scheduled-tasks-in-asp-net-with-quartz-net). Or you can use a Windows Service, or you can use the Task Scheduler on the server with a console app. Or you can use a SQL Server Job if you have the Agent installed on the server. 

    https://docs.microsoft.com/en-us/sql/ssms/agent/create-a-job?view=sql-server-2017

    The best and easiest approach for you will depend on what access you have to the actual server. If you have free access to the task scheduler, then the console app is likely to be the easiest.

    • Marked as answer by Anonymous Thursday, October 7, 2021 12:00 AM
    Tuesday, October 30, 2018 2:31 PM
  • User-1715638843 posted

    i got an option like creating an ssis package and scheduling a job in sql to run the package everyday.but will that create any problem when hosting?i dont know much about hosting

    Wednesday, October 31, 2018 4:30 AM
  • User-821857111 posted

    The services that each hosting company offers differs greatly. You need to ask your hosting company if they support that approach. 

    Wednesday, October 31, 2018 8:23 AM
  • User379720387 posted

    Create an Azure function that posts to one of your pages.

    The timer functions would be inside the Azure function.

    On your page you can have some logic to determine what you want do depending on what is being posted.

    One of my functions sends reminders to users every Mon-Fri at 8 AM, but you can easily trigger a db cleanup etc.

    https://docs.microsoft.com/en-us/azure/azure-functions/functions-create-scheduled-function

    Wednesday, October 31, 2018 3:27 PM