SQL Server Performance

DTS through JOB

Discussion in 'SQL Server DTS-Related Questions' started by dishanf, Mar 1, 2004.

  1. dishanf New Member

    Hi experts.<br /><br />is there a way to pass a parameter when calling a SQL Server job, that in turn passes the parameter to a DTS package. now im execute Job using sp_start_job. but i cant findout, is there a way to pass parameters.<br /><br />DishanF [<img src='/community/emoticons/emotion-1.gif' alt=':)' />]
    dishanf, Mar 1, 2004
    #2

  2. satya Moderator

    I don't think its possible to pass parameter to a scheduled job.
    And in DTS package use GLOBAL Variables you can pass as parameter using DTSRUN Utility, for more information review Books online andhttp://www.sqldts.com website.

    Satya SKJ
    Moderator
    http://www.SQL-Server-Performance.Com/forum
    This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
    satya, Mar 1, 2004
    #2

  3. dishanf New Member

    hmmmm.. Thanks for response. That means there is no way to do this ah.

    D!shan
    dishanf, Mar 1, 2004
    #2

  4. satya Moderator

    satya, Mar 1, 2004
    #2

  5. gaurav_bindlish New Member

    Store the input data in a table and program the job to read data from that.

    Gaurav
    Moderator
    Man thrives, oddly enough, only in the presence of a challenging environment- L. Ron Hubbard
    gaurav_bindlish, Mar 1, 2004
    #2

Share This Page