The Schema that is used to retrieve the access plan when the SQL statement is scanned is displayed in the File / Database Object column in the Job Manager window.
To change the schema used to scan a particular Job
-
Right-click a Job and select Set Schema.
-
Select the schema name from the list.