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
http://dineshasanka.spaces.live.com/

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. <hr noshade size="1">Satya SKJ Microsoft SQL Server MVP Contributing Editor & Forums Moderator http://www.SQL-Server-Performance.Com</a> <center>This posting is provided AS IS with no rights for the sake of knowledge sharing.</center>

]]>