Hi @ChongSunLimAP-4498,
Yes this is fully possible in SCOM, you can group the servers in the way you want, for example per application, and then configure the alerts to different groups/users as per your needs.
You can create roles in within SCOM and give your application owners certain rights so that they can use the maintenance mode feature to turn off alerts. For editing alert notifications in SCOM I believe you'll need to have SCOM administrator rights.
Below you'll find some useful links with information:
Subscribing to alert notifications
https://video2.skills-academy.com/en-us/system-center/scom/manage-notifications-alert-notifications?view=sc-om-2019
Operations associated with user role profiles
https://video2.skills-academy.com/en-us/system-center/scom/manage-security-create-runas-account?view=sc-om-2019
----------
(If the reply was helpful please don't forget to upvote or accept as answer, thank you)
Best regards,
Leon