several queries need ran daily w/output to text file

• wicasa71

  Newbie

  Points: 1

  More actions

  November 11, 2008 at 9:13 am

  #201094

  I am a noobie to SQL and need some help! I have several select queries I need to run on a daily basis in order to find an issue with our database. Is there a script I can generate that will run these daily with an output to a text or cvs file?

  Any assistance would be greatly appreciated!

  Jason

• torpkev

  SSCarpal Tunnel

  Points: 4819

  More actions

  November 11, 2008 at 9:37 am

  #897024

  use the sql server agent to schedule the job..

  and you could use a modification of:

  http://www.sqlservercentral.com/articles/Advanced+Querying/tippipequery/175/

  personally.. i'd output to another table in the database but thats just me.. i hate working with text files 🙂

  --------------------------

  I long for a job where my databases dont have any pesky users accessing them 🙂