Hi All,
I have created an SQL Job Script which has a store procedure that is used to send an email to different departments in my company. For each department, the parameter of the SP will change. I'm struggling to provide the recipient's email id a single script. As per my knowledge, we have to create different scripts for every department. In that case, I need to create more than 25 scripts. Can we have all the recipient's email in a single script at the same time, the SP parameter will differ based on recipients. Can any one help me?
Thanking you in advance...
Shanif