v2.0 Update - Githubissues

taddison commented 4 years ago

Significant changes incoming. There will be some upgrade instructions, but shooting for a 'zero-touch' upgrade path isn't part of the update.

[x] Remove the desc columns for frequency and store day/hour/minute
[x] Remove requirement for the identifier to be prefixed with the database name
[x] Change the task creation to automatically prepend the database name
[x] Add a unique identifier for each task
[x] Store the unique identifier for the scheduler instance and the task in the job description
[x] Support rename
[x] Database to/from job objects
[x] File system to/from job objects
[x] Comparison (given two sets of job objects produce the delta to bring them into alignment)
[x] Sync cmdlets (DB->Folder, Folder->DB, DB->DB, Folder->Folder)
[x] Guidance for migration from v1.x to v2.0

taddison commented 4 years ago

While working on this update @Morshedk came up with an incredibly helpful idea - rather than all of the dancing around AGs and if they're primary or not, we can simply check the databasepropertyex(db_name(), 'updateability') - and this means we can ditch the cached replica checks and there is no longer 'ag mode vs standalone'!

You can see these changes in this commit: https://github.com/DBTrenches/tsqlscheduler/commit/ba819882e9f8124e8ae50e2bf274b5d6e0830680

taddison commented 4 years ago

Currently working on the PowerShell job class which will support operations against either a database or the filesystem:

DBTrenches / tsqlscheduler

v2.0 Update #1