Calling SqlPlus in PowerShell RRS feed

  • Question

  • Hello:

    I am totally new to PowerShell, which is why I need help with the following project.

    I currently have a SQL script that I am able to run via sqlplus. The result is  sent into a text file in a specific location.

    I would like to be able to accomplish the following tasks:

    Step 1: I would like to have a PowerShell script that calls SqlPlus and outputs the result in a text file in a designated location. 

    Step 2: I would like to have this process (Step 1) automated so that it runs automatically at a specific time on a weekly basis. 

    Any help is greatly appreciated.

    Thank you very much for your attention.

    • Moved by Bill_Stewart Friday, July 7, 2017 6:58 PM This is not "scripts on demand"
    Wednesday, May 31, 2017 3:58 AM

All replies