SSIS package failed in sql server 2005 with error "The job failed.The Job was invoked by User sa.The last step to run was step 1 "

Question

Post reply

SSIS package failed in sql server 2005 with error "The job failed.The Job was invoked by User sa.The last step to run was step 1 "

harmanocp

Mr or Mrs. 500

Points: 562
More actions
July 30, 2008 at 10:56 am

#122617

when i m trying to run ssis package from sql server agent it give this error "The job failed. The Job was invoked by User sa. The last step to run was step 1 "
does sa have permission to run ssis packages from sql server agent.
please help me resolving this error..
its urgent

Viewing 7 posts - 1 through 6 (of 6 total)

You must be logged in to reply to this topic. Login to reply

todd_dawson Ten Centuries Points: 1240 More actions · Answer 1

Can you give more information please on what your trying to do on Step_1?

harmanocp Mr or Mrs. 500 Points: 562 More actions · Answer 2

thanks for reply

I m checking database integrity through the SSIS package

Its simple job. It works well within SSIS but when i run it from sql server agent then it gives error

todd_dawson Ten Centuries Points: 1240 More actions · Answer 3

Make sure the owner of the job stayed as 'sa' and didnt default to your username when you selected "new job..." under the SQL Agent.

Also look for a more detailed explaination as to why the job failed, look under the "Alerts" node under the SQL Agent, also look in your Job Properties to "View Job History", expand the job log by clicking on the plus sign next to the failure to see a more detailed reason.

The more information you provide the easier it will be to help you.

harmanocp Mr or Mrs. 500 Points: 562 More actions · Answer 4

well i have gone through job histroy... it always says "

Message

The job failed. The Job was invoked by User sa. The last step to run was step 1 "

Does i have to create proxy for job to work in sql server agent???

harmanocp Mr or Mrs. 500 Points: 562 More actions · Answer 5

problem solved!!!!

Create new CREDENTIAL and Proxy for SSIS package and use this proxy instead of sql server agent account..

phina_el SSC-Addicted Points: 408 More actions · Answer 6

Hi All..

I have some problem with you, but i try to created new CREDENTIAL and Proxy for SSIS Package Execution and use this proxy instead of sql server agent account, but still error.

Please share it to me...

Thanks