DTS Nightly Job | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

DTS Nightly Job

There is the SQlserver Database which has to send the data to SAP every day
it should be like DTS nightly job. I want to know about the Nightly job please give some tips
I think this job is schedule to run at night. check the schedule of the job. AFAIK, there is nothing called Nightly job —————————————-
Contributing Editor, Writer & Forums Moderator
http://www.SQL-Server-Performance.Com Visit my Blog at

Nightly [<img src=’/community/emoticons/emotion-1.gif’ alt=’:)‘ />], this is mentioned as you can export data during less traffic hours without impacting the performance, follow as suggested by Dinesh.<br /><br /><hr noshade size="1"><b>Satya SKJ</b><br />Microsoft SQL Server MVP<br />Contributing Editor & Forums Moderator<br /<a target="_blank" href=http://www.SQL-Server-Performance.Com>http://www.SQL-Server-Performance.Com</a><br /><center><font color="teal"><font size="1">This posting is provided AS IS with no rights for the sake of <i>knowledge sharing.</i></font id="size1"></font id="teal"></center>