Delete Notifications/Rules in mass

0
Does anyone have a process or SQL SP to delete Notifications in mass? We have a client using SBM that had 600+ notifications and they have left so we want to remove those notifications from the system. Doing it one at a time in Application Administrator is painful to say the least. After every delete we have to reselect the workflow and find where we left off.
I want to delete them in SQL and then just refresh the system but there are multiple tables associated with Notifications and I do not want to leave orphaned records.
Responses (3)
  • Accepted Answer

    Tuesday, January 22 2019, 11:28 AM - #Permalink
    0
    Attached is some SQL that will delete all the unused "Out-of-the-box" notifications created when SBM is installed or when a new Process App is deployed. Perhaps it will give you a head start.
    Note: It's for SQL Server. If you're using Oracle you'll need to convert the "IsNull" calls to "Coalesce" and do something with the "Declare" local variables.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, January 22 2019, 11:30 AM - #Permalink
    0
    Attached is some SQL that will delete all the unused "Out-of-the-box" notifications created when SBM is installed or when a new Process App is deployed. Perhaps it will give you a head start.
    Note: It's for SQL Server. If you're using Oracle you'll need to convert the "IsNull" calls to "Coalesce" and do something with the "Declare" local variables.
    The reply is currently minimized Show
  • Accepted Answer

    Tuesday, January 22 2019, 11:31 AM - #Permalink
    0
    Attached is some SQL that will delete all the unused "Out-of-the-box" notifications created when SBM is installed or when a new Process App is deployed. Perhaps it will give you a head start.
    Note: It's for SQL Server. If you're using Oracle you'll need to convert the "IsNull" calls to "Coalesce" and do something with the "Declare" local variables.

    File is NOT PDF -- it's ASCII text. I had to change the file extension to ".PDF" to attach it.
    The reply is currently minimized Show
Your Reply