locked
Manual execution Vs Scheduled Job execution RRS feed

  • Question

  • Hi All,

    I have a query and would appreciate your response / guidance.

    I have a CDC package which when I execute manually takes around 1 sec to finish but when I execute the same package via a SQL job it takes around 24 seconds.

    Can you please suggest what might be the issue?

    Please let me know if you need any information.

    Regards,

    Nikhil

    Monday, March 9, 2015 1:28 PM

All replies

  • Where is the package deployed? Is it in file system or msdb or SSIS catalog?

    Also is the package run with same config values from job as well?


    Please Mark This As Answer if it solved your issue
    Please Vote This As Helpful if it helps to solve your issue
    Visakh
    ----------------------------
    My Wiki User Page
    My MSDN Page
    My Personal Blog
    My Facebook Page

    Monday, March 9, 2015 1:35 PM
  • Hi Visakh,

    The packages are on file system. Yes the same package with same config is being run via job as well.

    Regards,

    Nikhil

    Monday, March 9, 2015 2:06 PM
  • Hi All,

    Any suggestions on the above mentioned issue?

    Regards,

    Nikhil

    Wednesday, March 11, 2015 6:32 AM