July 22, 2009 at 3:45 pm
Hi,
I have created two SSIS packages that will read the text files and update the values in the table. I have created sql server job for each of them and scheduled them to run every 2 minutes. The location of the packages are in the same folder. They both run under same login account. After running for some time, one of the jobs will go into infinite loop. If I start the job manually it says "cannot start job since there is a active job running." If I stop the job manually and run it again it works fine for few more iterations and then it hangs. Initially I thought there might be some problem in the ssis package. so I enabled logging and when I looked at the logs I don't see any error. Then I thought it might be because the jobs are running at the same time. so I changed the interval on one of the jobs to 5 minutes. still it hangs after few iterations.
Is there a way to track the problem? I tried opening the "Job Activity Monitor" but it gave me error "Cannot show requested dialog." Unable to execute requested command.
Viewing post 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply