Powershelgl script via Schedule Task

[vjosuz]

Hi All

I have a script which does below

1) Load oracle Library

2) Makes a connection to an oracle database and fetches some columns

2) I export it to CSV and do some processing (using a function) over CSV

3) Then I generate another CSV out of it

Final result returns me correct output when I open powershell (v 3.0) and run script but when I run it as a schedule task few of the columns come out as blank.

Schedule task options I have used

- Under General tab Run weather user is logged in our not (Do not store password is checked)

- Under actions tab --> program/script --> I type "powershell"

- Add arguments (optional) --> Script Name (example: test.ps1)

- Start in (optional) --> Path of script (example: c:\Temp)

Please advice

Thanks

Heera

[LucD]

Which columns are blank ? The ones that have values obtained through the Oracle library ?

Is the library loaded correctly ?

Could you show us part of the code ?