Skip to content

Instantly share code, notes, and snippets.

@iversond

iversond/disable_prcs_pn.sql

Created December 17, 2019 20:36
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save iversond/319269882bcd23206c885a895b11e17f to your computer and use it in GitHub Desktop.
Save iversond/319269882bcd23206c885a895b11e17f to your computer and use it in GitHub Desktop.
Download ZIP
Disable Process Scheduler Push Notifications
Raw
disable_prcs_pn.sql
-- Remove PRCS Request Submitted notifications
update sysadm.PSPTPNCOLLEVTS set event_name = ' ' where PTPNCOLLNAME = 'PRCSPTPNCOLLECTION';
commit;
-- Validation: Collection PRCSPTPNCOLLECTION should have no event_name set
select * from sysadm.PSPTPNCOLLEVTS where PTPNCOLLNAME = 'PRCSPTPNCOLLECTION';
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment