search

taddison / tsqlScheduler

Create and monitor agent jobs & execution from tables
MIT License
3 stars 0 forks source link

Add default job to auto-create tasks #10

Closed taddison closed 7 years ago

taddison commented 7 years ago

Once a task is in the table it should be treated as live. Potentially add the concept of IsEnabled or IsActive to allow the tasks to be staged/validated?

taddison commented 7 years ago

Might want to change this to be a procedure to create all jobs and then instructions for how to construct the job which does this work. With an AG this will have to be executed on all replicas, so will need a manual step.

taddison commented 7 years ago

Job will target a specific database so for now naming convention will reflect that, e.g. TaskDB-TSQLScheduler Maintenance