Job schedule is currently in used by XXX error when attempting to modify a Job Schedule

Issue

The following error is observed when attempting to modify a Job Schedule in KTA Designer:

Job schedule is currently in used by XXX error 

Solution

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

UPDATE JOB_CREATION_SCHEDULE

set LOCKED_BY = NULL

where SCHEDULE_NAME = 'name of job schedule'

Level of Complexity 

Easy

Applies to  

References

Add any references to other internal or external articles