SQL Agent job continues to run

Apr 15, 2009 at 6:33 PM
Has anyone been able to use the SharePoint list source in a package which is in a SQL Agent job step?

I can run the deployed package with dtexec without any issue, but when I run the SQL Agent job which includes this package the job continues to run indefinitely. I figure it's an issue with my security. I made a credential and proxy for my domain user which has access to the SharePoint list but it continues to run. If I use the SQL Service account in the job I get an Unauthorized response from SharePoint which is probably correct.

Has anyone had any success?

TIA
May 4, 2009 at 8:43 AM
Yes, I have been able to run the job using SQL agent. I too got permission issue initially. I ran the sql agent using the account having permissions at sharepoint and it ran successfully.


P.S. After updating sql agent account, restart the agent