DTS Scheduling problem | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Scheduling problem

Hi I created a schedule in DTS for 30 min
Do you i need to execute immedietly?
If I wait for 30 min it doesn’t reflect any rows.If i execute it immedietly it works and stops the execution once it is done, it doesn’t start for next 30 min. Permanently I want to schedule for every 30 min.
If I again schedule the task ,I am unable to see the last shcedule task.
Where the previous schedule task located?
Surendra Kalekar
Have a run thru KBAhttp://support.microsoft.com/default.aspx?scid=kb;EN-US;Q269074 and you can check last execution from EM using Management –> SQLAgents –> Jobs –> ‘named’ DTS Job. If nothing is happening then ensure SQLAGent has required privileges to carry on further tasks.
SQLAgent will take care of schedule that is defined for that job. Satya SKJ
This posting is provided “AS IS” with no rights for the sake of knowledge sharing.
Also, make sure the job AND the Schedule are both enabled.