locked
How to create Database for Quartz at Application start RRS feed

  • Question

  • User-1854646908 posted

    I want to use Quartz to create scheduled tasks in ASP.NET Core 2 web application.

    But Quartz needs its own database, how to create this database at the first of the start of application.

    I do not want to write code for its models like Db Context, i want to create it from script or schema.

    How to do that or what is the best approach in this situation?

    Monday, February 19, 2018 1:16 PM

All replies

  • User409696431 posted

    This is a Quartz question, and they already have tutorials.   Specifically, Tutorial 9 discusses your options for storing the information Quartz uses.  http://www.quartz-scheduler.org/documentation/quartz-2.x/tutorials/tutorial-lesson-09.html   A database is one option.  And, as it says in that tutorial, "You can find table-creation SQL scripts in the “docs/dbTables” directory of the Quartz distribution."

    Monday, February 19, 2018 8:55 PM
  • User-1854646908 posted

    KathyW

    This is a Quartz question, and they already have tutorials.   Specifically, Tutorial 9 discusses your options for storing the information Quartz uses.  http://www.quartz-scheduler.org/documentation/quartz-2.x/tutorials/tutorial-lesson-09.html   A database is one option.  And, as it says in that tutorial, "You can find table-creation SQL scripts in the “docs/dbTables” directory of the Quartz distribution."

    I already have the script of database i need and i can create it manually, but i want to create it dynamically when application start for first time, i am working on ASP.NET Core 2 code first project and my main database is created dynamically if not exist when application start and i want the Quartz db is created dynamically like my main db.

    Tuesday, February 20, 2018 1:06 AM