FIND_AND_CANCEL_QSQSRVR_SQL procedure
The FIND_AND_CANCEL_QSQSRVR_SQL procedure finds a set of jobs with SQL activity and safely cancels them.
The schema is QSYS2.
- job-name
- A character string containing a qualified job name.
The FIND_AND_CANCEL_QSQSRVR_SQL procedure uses the FIND_QSQSRVR_JOBS
and CANCEL_SQL procedures to determine the set of jobs that have SQL
activity for the provided job-name. Each of these jobs is made
a target of an SQL cancel request.
Example
Cancel all the QSQSRVR jobs used by a specific job.
CALL QSYS2.FIND_AND_CANCEL_QSQSRVR_SQL('564321/APPUSER/APPJOBNAME')