RE: Schedule query results to file...

Tech-Archive recommends: Speed Up your PC by fixing your registry

From: Alejandro Mesa (AlejandroMesa_at_discussions.microsoft.com)
Date: 01/26/05 

Date: Wed, 26 Jan 2005 11:09:07 -0800

Create a DTS package that execute the sp and schedule it.

AMB

"len" wrote:

> Hi there.
>
> I have many needs. One of these happens to be a requirement to set up a
> scheduled task which calls a simple stored procedure and then sent the
> resulting record set to a file - preferably in .csv format.
>
> Anybody any ideas how to go about this? My stored proc is very basic (select
> * from...) so there's nothing fancy with the resulting records it returns.....
>
> Any help would greatly appreciated!
>
> All the best,
> Len

Relevant Pages

  • Re: scheduling a t-sql stored procedures name in table column without creating a job for each on
    ... You want to schedule or simply run/put them on a Q and they run? ... Again I would still connect to SQL Server however it is that you want to do it, get all the possible procs from your Control table. ... I want to write a stored procedure that will ... You also do not need to use a Script task to do ...
    (microsoft.public.sqlserver.dts)
  • Re: Limitations of Scheduled jobs
    ... > Actually we can schedule the jobs with accuracy less than ... where executing the stored procedure ... >>on what the stored procedure does exactly. ... >>SQL Server MVP ...
    (microsoft.public.sqlserver.programming)
  • Re: Limitations of Scheduled jobs
    ... Actually we can schedule the jobs with accuracy less than ... >on what the stored procedure does exactly. ... >SQL Server MVP ... >> I'm using SQL Server 2000 as the DB for my web ...
    (microsoft.public.sqlserver.programming)
  • Re: scheduling a t-sql stored procedures name in table column without creating a job for each on
    ... I want to write a stored procedure that will ... And by schedule I mean run as a job now. ... You also do not need to use a Script task to do ... loop over them and execute them using a combination of the ForEachLoop ...
    (microsoft.public.sqlserver.dts)
  • Re: excecuting stored procedures
    ... Can I Schedule excecution of stored procedure in crystal report XI. ... You want to schedule the stored proc (I'm assuming on MSSQL?) to run based ... on a given time from within Crystal Reports? ...
    (microsoft.public.vb.crystal)