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.

Read syntax diagramSkip visual syntax diagramFIND_AND_CANCEL_QSQSRVR_SQL( job-name )

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')