Get notification after sql job finished via Microsoft Teams

Copper Contributor

Hello everyone,

 

I want to get informations- is it failed or succeed-to my microsoft teams after an sql job finished.

 

If it is failed what is error message? I searched a lot but could not find an exact solution. 

 

Can anyone help me pls?

1 Reply
You can try following approach:
Once SQL Job finished, create record in database
Configure Power automate to trigger based on new record creation in database table
Power automate can send notification to users in Microsoft teams via Flow bot.