July 28, 2009 at 3:20 am
Hi All,
I have an SSIS package which i have scheduled to run as a Job in SQL SERVER 2005. My question is how do I add alerts? if i try do that i get the error" Object reference is not set to an instance of object." Also for notifications if I choose e-mail under "actions to perform when the job completes" where do i put an e-mail address as i only get a drop down i cannot type into.
Many thanks.
July 28, 2009 at 6:52 pm
phumlo1 (7/28/2009)
Hi All,I have an SSIS package which i have scheduled to run as a Job in SQL SERVER 2005. My question is how do I add alerts? if i try do that i get the error" Object reference is not set to an instance of object." Also for notifications if I choose e-mail under "actions to perform when the job completes" where do i put an e-mail address as i only get a drop down i cannot type into.
Many thanks.
You are probably looking to add a notification, not an alert. To add notifications you will need to have database mail configured and enabled in sql server agent. after that you can add operators under sql server agent, and you will be able to select your operator under job notifications. As far as the error message is concerned, you can search for the error message + ssms, it looks like people were able to solve the problem by reinstalling workstation components.
July 29, 2009 at 12:58 am
Thanks you are right. I didnt have database e-mail configured.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply