search

TheDataShed / sql-deployment-tools

GNU General Public License v3.0
2 stars 0 forks source link

More Job Schedule Options #38

Open gvee-uk opened 2 years ago

gvee-uk commented 2 years ago

The MVP version of this app supports running jobs on a fixed, recurring schedule ("every N minutes").

However SQL Agent supports a far wider array of possibilities:

SQL Agent Job Schedule

This issue can likely be split in to multiple "sub-issues" to deliver different pieces of the functionality based on their usage needs.

Some examples:

  1. Once a day running e.g. runs at 11PM every day (might be useful for maintenance tasks)
  2. A schedule that has a maintenance window e.g. runs daily from 6AM to midnight.
  3. Specific days of the week e.g. a job that only runs on weekdays
  4. Runs once a month on a specific day e.g. the 1st of each month