Results 1 to 6 of 6
  1. #1
    Join Date
    Jun 2002
    Posts
    6

    Question Unanswered: programmatically schedule the package for later execution in store procedure

    Hello,

    Is it possible programmatically schedule the DTS package for later execution in store procedure or maybe in trigger?

  2. #2
    Join Date
    Feb 2002
    Posts
    2,232
    When you say later execution, please be more specific and describe the scenario you are trying to apply this to.

  3. #3
    Join Date
    Jun 2002
    Posts
    6
    Originally posted by rnealejr
    When you say later execution, please be more specific and describe the scenario you are trying to apply this to.

    For example, user sets flag thru user interface. This action updates some field in table. I would like to have an "update" trigger for this table that will schedule the DTS package to be executed at night. There is some option to do it in VB but it will be cool to perform this thru store procedure.

  4. #4
    Join Date
    Feb 2002
    Posts
    2,232
    You can use the sp_add_schedule or sp_update_schedule - however, a job must already exist for the DTS package.

  5. #5
    Join Date
    Jun 2002
    Posts
    6
    Thank you. It's msdb..sp_update_jobschedule.

    Thanks again!

  6. #6
    Join Date
    Feb 2002
    Posts
    2,232
    Happy to help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •