Post reply

Having Problem with SQL Server Agent 2005

  • September 18, 2006 at 7:24 pm

    #114947

    Hi there,

    in my project, i suppose to create a schedule to run the SSIS package, so i try to use SQL Server Agent. I've created Credential, Proxy Account follow by Job Schedule.

    and when i run the job i get this error:

    Message

    The job failed. The Job was invoked by Schedule 7 (Schedule1). The last step to run was step 1 (Step1).

    Unable to start execution of step 1 (reason: Could not get proxy data for proxy_id = 6). The step failed.

    Could anyone explain to me what are this errors mean, and how to solve this error?

    Thanks

  • September 18, 2006 at 10:15 pm

    #661163

    Now I'm having another problem after did some changes:

    "Executed as user: DOMAIN\USERNAME. The package execution failed. The step failed."

    Anyone has any idea how to solve this problem??

  • September 19, 2006 at 1:21 am

    #661183

    Problem's Solved!!!

    Just need to install SSIS server then everything run as expected

  • June 21, 2007 at 9:04 am

    #714389

    You made some changes that seem to have removed the first error message you had "could not acces proxy data": can you tell me what changes you made? I'm stuck there, cna't figure out what I4m missing.

    I'm coming quite late, but hope someone will still be here to help...

    Thanks in advance!

Viewing 4 posts - 1 through 4 (of 4 total)

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