|
|
|
#1 |
|
Messages: n/a
Hébergeur: |
using DTS to output scheduled query to csv ?
Hi, I need to run a bunch of queries out with office hours when the system is quiet. Im using SQL agent to scheudule a query but i cannot seem to output the results c:\output.csv Easy when running a non-schedule query. Thanks for any Scott |
|
|
|
#2 |
|
Messages: n/a
Hébergeur: |
"Scott" <scott_lotus@yahoo.co.uk> wrote in message
news:ujtQYUC6IHA.1196@TK2MSFTNGP05.phx.gbl... > using DTS to output scheduled query to csv ? > > Hi, > > I need to run a bunch of queries out with office hours when the system is > quiet. Im using SQL agent to scheudule a query but i cannot seem to output > the results c:\output.csv > > Easy when running a non-schedule query. > > Thanks for any > Scott When a "job" is scheduled it runs under the security context of the windows account that runs the SQL Agent service. Does this account have the necessary NTFS permissions to write/modify to c:\output.csv? |
|
![]() |
| Outils de la discussion | |
|
|