Reallocating Job schedules

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:

update JOB_CREATION_SCHEDULE
set LOCKED_BY = NULL
where SCHEDULE_NAME = 'TestSchedule'

You will need to change the name of the Scheduled Job in the query.

Applies to: