SQL Server Performance Forum – Threads Archive
DTS Scheduling problem
Hi I created a schedule in DTS for 30 minDo 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
Moderator
http://www.SQL-Server-Performance.Com/forum
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.
]]>