Syrna.QuartzAdmin

Quartz Enterprise Scheduler .NET Admin UI with Blazor, WebApi and Abp Framework

An abp application module that allows manage quartz scheduling.

Installation

1. Install the following NuGet packages. (see how)

   • Syrna.QuartzAdmin.Application
   • Syrna.QuartzAdmin.Application.Contracts
   • Syrna.QuartzAdmin.Domain
   • Syrna.QuartzAdmin.Domain.Shared
   • Syrna.QuartzAdmin.EntityFrameworkCore
   • Syrna.QuartzAdmin.HttpApi
   • Syrna.QuartzAdmin.HttpApi.Client
   • Syrna.QuartzAdmin.Web
   • Syrna.QuartzAdmin.Blazor
   • Syrna.QuartzAdmin.Blazor.Server
   • Syrna.QuartzAdmin.Blazor.WebAssembly

2. Add DependsOn(typeof(QuartzAdminXxxModule)) attribute to configure the module dependencies. (see how)

3. Add builder.ConfigureQuartzAdmin(); to the OnModelCreating() method in MyProjectMigrationsDbContext.cs.

4. Add EF Core migrations and update your database. See: ABP document.

Requirements

• .NET 9
• ABP 9.1.1
• Quartz 3.13.0+

Features

• Add, modify jobs and triggers
• Support Cron, Daily, Simple trigger
• Pause, resume, clone scheduled jobs
• Create custom UI to configure job
• Dynamic variables support
• Monitor currently executing jobs
• Load custom job DLLs through configuration
• Display job execution logs, state, return message and error message
• Filter execution logs
• Store execution logs into any database
  • Build-in support for SQLite, MSSQL and PostgreSQL
• Auto cleanup of old execution logs
  • Configurable logs retention days
• Build-in Jobs
  • HTTP API client job
• InterruptJob implemented

Usage

1. You must create quartz database. You can find sql mssql script https://github.com/SyrnaAbp/Syrna.QuartzAdmin/blob/dev/demos/MainDemo/src/Syrna.QuartzAdmin.MainDemo.DbMigrator/sqlserver.sql
2. If you will change database, get your sql script from https://github.com/quartznet/quartznet/tree/main/database/tables
3. modify your appsettings.json
4. More details can be found at QuartzAdmin

PostgreSql

"ConnectionStrings": {
  "Default": "Host=<db_host>;Port=5432;Database=<db_name>;Username=<db_user>;Password=<db_password>"
},
"Quartz": {
  ...
  "quartz.jobStore.driverDelegateType": "Quartz.Impl.AdoJobStore.PostgreSQLDelegate, Quartz",
  ...
  "quartz.dataSource.myDS.provider": "Npgsql"
},
"QuartzAdmin": {
  "DataStoreProvider": "PostgreSQL",

MsSql

"ConnectionStrings": {
 "Default": "Server=(LocalDb)\\MSSQLLocalDB;Database=SyrnaQuartzAdmin;Trusted_Connection=True"
},
"Quartz": {
  ...
 "quartz.jobStore.driverDelegateType": "Quartz.Impl.AdoJobStore.StdAdoDelegate, Quartz",
  ...
  "quartz.dataSource.myDS.provider": "SqlServer"
},
"QuartzAdmin": {
  "DataStoreProvider": "SqlServer",

Screenshots