Using the SQL Server Agent for the first time
I have set up several jobs to run automatically throughout the day. Each job just does one thing: executes an SSIS package.
The packages themselves run perfect when I test them in Visual Studio 2005, but when the SQL Server Agent tries to run the job I am getting failed jobs.
Is there any tutorials or walkthroughs that can teach my about using the SQL Server Agent? If I wanted extensive help troubleshooting my SQL Server Agent problems which part of the message boards would I post that too?
Thanks for the info!
When you run an SSIS package on your workstation, you are running it using your Windows security context. When it executes via the SQL Server Agent, it is running on the server using the context that the Agent is running with. First - is the package owner a sysadmin? Second, have you set a SQL Server Proxy account up for the Agent? Sounds like a permission problem to me.
Brad Feaker
Brad,
Thanks for the advice. I created the SSIS package on the server that the SQL Server Agent is also running on. I was logged into the server as myself when I created the package and I do have sysadmin rights. I have not set up a SQL Server Proxy account, however, so that might be where I am running into problems.
I would like to hear more about this Proxy account thing. I am completely unfamiliar with it. Thanks!
Are there any books online or any other resources that people know of that give me a step-by-step how-to for the new SQL Server 2005 Agent?
Any help/advice/tips/tricks are much appreciated!
