i have a package which will execute fine manually but when i try to schedule it, it fails immediately (within the first second).
i can even right click on the scheduled package and do "generate sql script" and then run that script and again, no problem. it just will NOT schedule.
any ideas?
Package? Are you using Oracle or SQL Server?
|||
Depends on what your package is doing. Are you accessing external files? If so, you need to realize who your logged in user is for the job. When you run them manually, they execute as the runner.
Nick
|||When you execute the package it is running on your permissions but schedule is running on SQL Server Agent permissions. If your SQL Server Agent is installed with local systems account as most developer installations are the schedule fails because SQL Server Agent does not have to permissions to run the package. try the links below to configure SQL Server Agent permissions. Hope this helps.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_8sdm.asp
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/tsqlref/ts_xp_aa-sz_4jxo.asp
No comments:
Post a Comment