NEED HELP...SQL 2005 Job keeps failing everytime. Created job proxy and credential etc.

Posted on 2007-08-04
Last Modified: 2010-03-19
Hi all.  I cant seem to figure this out.  I had a SQL 2K DTS package where I transferred it over as a SSIS package and changed everything over etc.  I can manually run the package without any problems.  I created a job proxy and credential etc.  I can run the job manually with no problem.  When it is scheduled however it fails everytime.  How can I troubleshoot this?  I dont know what to change and what is going on as it seems if I am logged onto the PC it works fine.  Is there a way to change the owner of the package or something to admin?  No idea what to do from here as I am really hating SQL 05 right now.
Question by:sbornstein2
    LVL 50

    Accepted Solution

    what error does it fail with?
    check the job step history....

    it sounds like a permission issue

    what is the job doing... writing files / read files...?


    Author Comment

    if I am logged onto the PC the job runs fine even when its scheduled.  Once I logoff it fails everytime.  The error is:

    Executed as user: SGIDOMAIN\mwalsh. The package execution failed.  The step failed.

    so its definatly a permission issue but why does it run fine scheduled when I am logged onto the PC?
    LVL 50

    Expert Comment

    when you logon do you automatically bring in other network drives/devices that the job needs?

    that wont happend in the background...?

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Better Security Awareness With Threat Intelligence

    See how one of the leading financial services organizations uses Recorded Future as part of a holistic threat intelligence program to promote security awareness and proactively and efficiently identify threats.

    If you having speed problem in loading SQL Server Management Studio, try to uncheck these options in your internet browser (IE -> Internet Options / Advanced / Security):    . Check for publisher's certificate revocation    . Check for server ce…
    In SQL Server, when rows are selected from a table, does it retrieve data in the order in which it is inserted?  Many believe this is the case. Let us try to examine for ourselves with an example. To get started, use the following script, wh…
    This video is in connection to the article "The case of a missing mobile phone (". It will help one to understand clearly the steps to track a lost android phone.
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    737 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    17 Experts available now in Live!

    Get 1:1 Help Now