Post reply

differnce between Jobs and DTS packages

  • July 30, 2005 at 2:43 am

    #167824

    Hello friends

    Can any body tell me what is basic differnce between Jobs and DTS packages

    Can we run jobs by DTS or viceversa

    T.I.A

    Shashank

    Regards,

    Papillon

  • August 1, 2005 at 3:31 am

    #578448

    For more detailed information, check Books On Line.

    For a brief answer:

    DTS Packages are a way of perfroming processes (e.g. importing and exporting data in sql server). They can also peform other actions such as processing MDX olap cubes....etc

    For example, copying a table in one database to another.

    Jobs are similar to windows scheduled tasks and can be scheduled. They initiate processes.

    For example, running a sql script that updates a table periodically.

    The jobs can also call a dts packages to run it at a one off date and time or at specific intervals. I.E daily at 9.00 am.

     

    ------------------------------
    The Users are always right - when I'm not wrong!

  • August 1, 2005 at 1:18 pm

    #578652

    To answer the vice versa part of the question:  a DTS package can execute a job also using sp_start_job.

    Greg

    Greg

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

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