Changing the priority of all jobs in a session

The admin user and users with the Manage System privilege can set the priorities of all jobs in a session to a single priority.

For example, to change the priority of all jobs of the session with the ID 21664 to HIGH:
  • By issuing the nzsession priority command, enter: 
    nzsession priority -high -u user -pw password -id 21664
  • By issuing the ALTER SESSION command, enter: 
    MYDB.SCHEMA(USER)=> ALTER SESSION 21664 SET PRIORITY TO HIGH;

Use the nzsession show command to show information about the current sessions and their priorities.