SQL Server Performance Forum – Threads Archive

Question on Job Schedule

Hi All, I encounter the following problem : I create a SSIS in VS2005, it can run successfully in there. then i save the package into Server, and execute it. It still can be run successfully then i make a job which run this package regularly, it run failure. Even I start the job manually, it also fail. this is the message:
Date7/18/2007 5:41:24 PM
LogJob History (a) Step ID1
ServerHITSQL034
Job Namea
Step Name1
Duration00:00:27
Sql Severity0
Sql Message ID0
Operator Emailed
Operator Net sent
Operator Paged
Retries Attempted0 Message
Executed as user: HITDOM00OICSQLAG. The package execution failed. The step failed. I guess this is due to the Job Agent. But dont know how can i set it Thanks,
Linus

---

Hi,
I feel there must be some permission issues.
Log says that job actually ran for 27 seconds which means it must have started the package.
Start the job manually and check under running packages in integration service.
This will imply whether the package actually gets executed by job or not.
Also have you specified any configuration files.

---

where can i set the permission for that?

---

What are the privileges for the SQLAgent service account on SQL Server?
You can edit that job to run under SA account or your account to continue without any issues. Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
http://www.SQL-Server-Performance.Com
@http://www.askasqlguru.com/ This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.

---

]]>