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 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.
Authorization: The caller must have:
- QSYS2/FIND_QSQSRVR_JOBS() authorizations, and
- QSYS2/CANCEL_SQL() authorizations
The schema is QSYS2.
- job-name
- A character string containing a qualified job name.
Example
Cancel all the QSQSRVR jobs used by a specific job.
CALL QSYS2.FIND_AND_CANCEL_QSQSRVR_SQL('564321/APPUSER/APPJOBNAME')