Simple question, but need help quickly
-
Totally new to SQL*Server. I was just asked to export rows from a Table using the DTS Import/Export Wizard (to a comma delimited flat-file). It was very simple, but I need to Schedule a Job to do this export once a week. Just learned how to schedule a Job to EXEC a stored procedure.
How do I schedule a Job to start an Export of one table ? Thanks! Wendy
-
Welcome to SQLServer's community.
If you have saved the DTS-package, then you can rightclick on it and there is an option "schedule job".
Just verify that sqlagent is running and that the account which is stored in the job, has the needed rights to execute the dts.
I hope this gets you started
Johan
Learn to play, play to learn !Dont drive faster than your guardian angel can fly ...
but keeping both feet on the ground wont get you anywhere :w00t:- How to post Performance Problems
- How to post data/code to get the best help[/url]- How to prevent a sore throat after hours of presenting ppt
press F1 for solution, press shift+F1 for urgent solution 😀
Need a bit of Powershell? How about this
Who am I ? Sometimes this is me but most of the time this is me
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply