The following error is observed when attempting to modify a Job Schedule in KTA Designer:
Job schedule is currently in used by XXX error
1) If the User is actively in the Job schedule, then the message applies.
2) If the User stated in the message is not in the Job schedule or no longer with the company etc, then the following SQL query can be used. It is recommended to take a backup of this table.
-- Run against main KTA database
set LOCKED_BY = NULL
where SCHEDULE_NAME = 'name of job schedule'
Level of Complexity
Add any references to other internal or external articles