Results 1 to 2 of 2

Thread: Scheduled Jobs

  1. #1
    Join Date
    Feb 2003

    Unanswered: Scheduled Jobs

    When creating a scheduled job is it possible to output the file to a shared drive on the network

    When browsing for file location whien creating the job only local physical drives are shown and when inputting unc share the job fails

    any ideas ?

  2. #2
    Join Date
    Oct 2002
    Leics, England
    If you know the name/IP address of the network file then you can output the file by using:


    where 'd$' is the drive you're writing to on that server.

    (NB This doesn't work if you are doing any file handling using the Scripting Runtime DLL through T-SQL)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts