Post reply

ssis package through sql server agent

  • May 21, 2008 at 4:41 am

    #125366

    Hi,

    I am facing a problem with ssis package running in sql server agent job

    I have created some ssis packages and it is been running by jobs for the last two year without any issues. But i identified a problem in execution of ssis packages getting delayed from the last week onwards. All the packages now it is executing with additional 1 minutes. I have changed any settings in server, but i restarted the sql server last week. From that day onwards i got this issue

    Please help me out to solve this issue..

    Regards

    Satheesh

  • May 21, 2008 at 7:48 am

    #818567

    So you're saying that your packages are now taking an extra minute?

    If that's a huge problem, then have you tried seeing if something is blocking? Perhaps you have contention somewhere. Were I you, I would try to see what performance issues I could be having.

    Watch my free SQL Server Tutorials at:
    http://MidnightDBA.com
    Blog Author of:
    DBA Rant – http://www.MidnightDBA.com/DBARant

    Minion Maintenance is FREE:

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

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