The notification page settings are stored in table:
To turn-off notification, the following steps can be followed:
1. Identify which JobSets, PSJobs, or processes have notification enabled, query the following tables.
SELECT * FROM PS_SCHDLNOTIFY
SELECT * FROM PS_PRCSJOBNOTIFY
SELECT * FROM PS_PRCSDEFNNOTIFY
2. Using the results of the queries above, turn-off notification of each definition through PIA, or simply update the tables through SQL.
Even if it may be tedious to turn-off notifications on each definition through PIA, this is the recommended way.
If you plan to turn off the notification through PIA, remove the row of notification with the minus sign (-).
That will ensure the notification set being removed from the tables completely.
To access the notification page of each definition through PIA, navigate to:
PeopleTools > Process Scheduler > Schedule JobSets
PeopleTools > Process Scheduler > Jobs
PeopleTools > Process Scheduler > Processes
To update the definition through SQL, simply remove the rows from the following tables:
Once all the definitions have been updated, CACHE on the process scheduler needs to be cleared and process scheduler to be re-booted for the changes to take into effect.