Execute a Stored Proc in the Background Job

• sureshj

  Valued Member

  Points: 74

  More actions

  January 28, 2009 at 4:57 pm

  #125961

  Hi,

  I have a SP, which will return rows of data. I want to run this procedure as a nightly batch using the Jobs, and I want to store the result set in a txt file or an excel file where I can access it. Can anyone please help me in how to do this in SQL 2005 Server.

  Thanks

  Suresh

• Grant Fritchey

  SSC Guru

  Points: 399278

  More actions

  January 29, 2009 at 7:41 am

  #934680

  Take a look at the information availabe on SQL Server Agent in the Books Online. You can do exactly what you want through there.

  "The credit belongs to the man who is actually in the arena, whose face is marred by dust and sweat and blood"
  - Theodore Roosevelt

  Author of:
  SQL Server Execution Plans
  SQL Server Query Performance Tuning