I know that the delivery alerting dashboard is useful to get alerts or notification in case of failure, however the only thing that it is missing is alerting at individual delivery, as it only sends alerts which has an aggregate of all deliveries matching that criteria.
Is there some way I can achieve this?
Workflow etc, it would be great if someone can guide me.
The workflow notification would work where you want an alert in case of a delivery failure. For the use case where you are looking for all the successful alert messages, you can create custom delivery alert criteria with filter as delivery ID=<your delivery ID> and status "Finished". In case you also want a dashboard report for all the failures of this specific delivery instead of each failure alert, you can create another custom criteria for status = "failed. To create a custom alert criteria, create a custom resource ie extension of an existing delivery resource and add the filters as I mentioned.
You can use a workflow for the delivery and edit the workflow properties to send error notifications to a chosen security group whenever that workflow is in error. These notifications are disabled by default.
Edit workflow properties > General > Execution > Error Management > Supervisors (select a group to be notified on error).