May 15, 2011 at 1:22 am
I want to create a Job scheduler in SQL Server 2008 that should be create a log in text file and stored in some other drive automatically. So for that I think I must need some script. So may be you can give me the right suggestion to resolve my issue.
Thanks.:discuss:
May 15, 2011 at 5:31 am
You could use a WINDOWS scheduled task calling a bcp out command with a trusted connection.
Regarding details for bcp please see BOL (BooksOnLine, the SQL Server help syste usually installed together with SQL Server).
Another option would be using a SQL Server job and xp_cmdshell but that should require additiona lsteps to avoid making xp_cmdshell available for every user (which would open a security hole of unknown depth).
A third solution would be a SSIS package called.
I, personally, would use either the first or the second option.
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy