NYC-Parks / SLADB

Service Level Agreement Database
2 stars 0 forks source link

Update insert, update triggers for tbl_change_request and change_request_status to toggle job on/off #14

Open GeoDan87 opened 3 years ago

GeoDan87 commented 3 years ago

https://docs.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-update-job-transact-sql?view=sql-server-ver15

Trigger can end with setting @enabled = 1, reset it to @enabled = 0 in the daily job.

GeoDan87 commented 3 years ago

https://dba.stackexchange.com/questions/70069/giving-file-system-access-to-the-sqlserveragent-virtual-account