tanj1035
asked on
where to change the recipient email in sql job
hi Experts,
I have updated the variables ( recipient emails ) in SSIS package. When I run the package, the ssis can send the report to the updated recipient email correctly. But, the recipient can not get the report automatically from sql job. I thought the tab "set value" which should capture the recipient email (see in the attachment ) and there was nothing there.
Where can I change the recipient email in sql job and have the recipient to receive the report automatically.
Thank you
Capture.PNG
I have updated the variables ( recipient emails ) in SSIS package. When I run the package, the ssis can send the report to the updated recipient email correctly. But, the recipient can not get the report automatically from sql job. I thought the tab "set value" which should capture the recipient email (see in the attachment ) and there was nothing there.
Where can I change the recipient email in sql job and have the recipient to receive the report automatically.
Thank you
Capture.PNG
Go to Configuration tab from the same screen and from Parameters tab tab you should be able to set the recipient email.
ASKER
Rex, thanks for your reply. I went to the configuration tab. It was blank and there is no parameters tab in that screen . Can you give me more details? thanks.
Ok. Now I understand the issue. You have a variable in the package which is local to the package unless it is a Parameter. My above suggestion was to set parameter runtime through job. If you want to stick with variable, you may need to hard code the value to recipient email under the variables with in the package and re-deploy it. see attached image.
Otherwise parameters can be used to pass these values runtime which may need changes in package.
Capture.PNG
Otherwise parameters can be used to pass these values runtime which may need changes in package.
Capture.PNG
ASKER
I have updated the recipient email in the variable and have build the solution ( see the attachment). The report was sent to the recipient email right away. But, in the sql job, the report was not sent to the updated recipient email automatically. So, I was wondering where I can update the recipient email in this specific sql job?
Capture.PNG
Capture.PNG
From screenshot, variable looks good. Then check the permission to the user/account under which the job runs has access to send mail.
ASKER
Rex, can you show me where the permission is? I am new to sql job and did not see it in there. Thank you.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
This is very helpful, Rex. Thanks for your detailed explanation!!