SQL Server Performance Forum – Threads Archive
DTS Scheduling problemHi 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?
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.