Question / Problem:
A Job Schedule set by a person that is no longer with a company is currently locked. They do not have the login password for that person. They not able to find where that lock would be. Is there a time period after which the Job Schedule will become unlocked again? Any way to remove that lock?
Answer / Solution:
Please, Backup all TotalAgility DBs then run the following update:
set LOCKED_BY = NULL
where SCHEDULE_NAME = 'TestSchedule'
You will need to change the name of the Scheduled Job in the query.