Post reply

Jobs Hanging

  • March 28, 2006 at 5:05 pm

    #365727

    I have several jobs that have been running successfully for years that a week and half ago began to hang.  The status on them is simply: Executing Job Step '1(Job Name)'  Within the job it actually creates a table and then loads data into it from a csv file.  The table is getting created so it is hanging on the data load.  The csv file is actually on another server. 

    Coincidently, there is one other job that runs an executable from the other server as well with a comand line parameter and it too is hanging in the same way.  Other jobs are still running fine.

    I can go and execute the packages themselves and they run fine.  This leads me to believe that it is a permissions issue but our network administrator assures me that nothing has changed.  I have also not changed anything on the SQL Server itself.

    Any thoughts on what I could try or look at would be greatly appreciated.  Thanks.

     

  • March 29, 2006 at 3:08 am

    #629410

    Hi,

    have a look at the event logs of your servers. Are there any events about loosing the connection to the domain servers?

    Are security events logged on these servers? Any errors correlating to your jobs?

    regards karl

    Best regards
    karl

  • March 29, 2006 at 11:18 am

    #629601

    There is nothing in the logs pertaining to loss of connections or related to the jobs in question.

    Also checked the permissions and the SQL Service Agent service login does have permissions to the directory where the files we are importing are located.

    The mystery continues...

  • March 29, 2006 at 11:43 am

    #629611

    Did you restart the SQL Service Agent yet?

    Best regards
    karl

  • March 29, 2006 at 11:45 am

    #629612

    Not specifically, but since we started having these issues we did restart the entire server and that didn't make a difference.

  • March 29, 2006 at 11:47 pm

    #629719

    Just to ask for the obvious, inside the job, the job-steps are running as sa or with a windows account?

    Best regards
    karl

  • March 30, 2006 at 8:12 am

    #629872

    In the job the owner is SA.  There is only one step in the job because it is running a package and everything I need it to do I am doing in the package.  The package is fairly simple, it creates the table and then moves data from a csv file to the newly created table.  I know that it is at least creating the table because it appears in the database.

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

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