Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
Starlet_GT
Yak Posting Veteran
81 Posts |
 Posted - 2007-05-28 : 08:51:58
|
| I have various ssis packages which need to schadule through SQL server agent, I manage to schadule those packages but every time SQL server agent execute those packages automaticlly they failed ... I went to package log and it gives error that Step one failed, on the other hand if i execute those packages through "Execute Package Utility", they run without any error ...Please Help... |
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-28 : 12:26:48
|
| Does sql agent service account have proper permission? Who is job owner? |
 |
|
|
Starlet_GT
Yak Posting Veteran
81 Posts |
Posted - 2007-05-29 : 00:42:09
|
| How to check the proper permission for SQL Server Agent, the job owner is "sa" |
|
|
|
Starlet_GT
Yak Posting Veteran
81 Posts |
Posted - 2007-05-29 : 00:51:44
|
quote:
Originally posted by rmiao
Does sql agent service account have proper permission? Who is job owner?
In admin tools/services i checked the agent but it was not running, i tried to start the services, but following error occures."The SQL Server Agent(SQLServer2005) service on local computer started and then stopped. Some services stop automaticlly if they have no work to do, for example, the Performance Logs and Alert Services" |
|
|
|
rmiao
Master Smack Fu Yak Hacker
7266 Posts |
Posted - 2007-05-29 : 13:46:53
|
| What's service startup account? Is it member of sysadmin? |
|
|
|
|
|
|
SSIS Execution Failed by SQL Server Agent