Post reply

job output files to another server

  • September 1, 2005 at 9:54 am

    #165836

    I am trying to create jobs in SQLServer 2000 of two different types.

    One would use a select query, another a DOS dir command. In both cases I want to output the results to a file. I can do that on the server. But I would like to output the files to another server.

    Through Enterprise Manager it is only giving me the local drives as an option... On the dos cmd I tried to output the file in the command line (dir xxx > z:\xxxxetc) 

    Is this possible through EM?  If not is there another way, e.g. can I do all this through a stored procedure and just use the job to call the sp?

    Thanks!

  • September 1, 2005 at 11:20 am

    #586947

    I did get the command line step to work. Had to use the format \\server\dir\dir~1\dir\file

    The one dir  name was too long and I was initially trying to use the shared drive letter.

    My other steps use a sql query to get the info. As far as I can tell I can only use the option for the output file on the Advanced tab. But that only gives me local drives.

    Any ideas?

    Thanks!

  • September 1, 2005 at 11:39 am

    #586961

    see if xp_cmdshell can help you.

    Kindest Regards,

    Amit Lohia

  • September 1, 2005 at 10:34 pm

    #587087

    EM will only show local drives, you can type in UNC paths and have it use them, just be sure that the service accounts for SQL Server / SQL Agent have permissions for the UNC paths.

    Andy

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply