How to Schedule a Job in SQL Server Database Creation Script

SQLServerCentral is supported by Red Gate Software Ltd.

Popular Topics

Home

Members

Calendar

Who's On

Home » Article Discussions » Article Discussions by Author » Discuss Content Posted by Jon Reade » How to Schedule a Job in SQL Server Database...

How to Schedule a Job in SQL Server Database Creation Script

Rate Topic

Display Mode

Topic Options

Author

Message

gyani

Posted Sunday, May 15, 2011 1:22 AM

Forum Newbie

Group: General Forum Members
Last Login: Thursday, July 21, 2011 8:30 AM
Points: 1, Visits: 7

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

Post #1108871

LutzM

Posted Sunday, May 15, 2011 5:31 AM

SSCertifiable

Group: General Forum Members
Last Login: Wednesday, June 12, 2013 12:04 PM
Points: 6,739, Visits: 12,167

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.

Lutz
A pessimist is an optimist with experience.

How to get fast answers to your question
How to post performance related questions
Links for Tally Table , Cross Tabs and Dynamic Cross Tabs , Delimited Split Function

Post #1108888

« Prev Topic | Next Topic »

Permissions