Scheduled Task Exchange 2010 powershell fails to execute properly

I have a wonderful script from Exchange Server Pro that I'e modified a bit to meet my needs. This script is typically run using parameters to provide instructions for its execution. It looks like this:

.\Get-MailboxReport.ps1 -customAttribute1 hcca -filename hcca.csv

Open in new window

I've created a second powershell script that contains a number of lines like above to create separate .csv files for each of our shared services members. The script also emails the appropriate .csv to each client.

This second script works perfectly but I need to schedule this as a task. So I created a .bat file with these contents:

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command ". 'C:\Program Files\Microsoft\Exchange Server\V14\bin\RemoteExchange.ps1'; Connect-ExchangeServer -auto; C:\Scripts\Exchange2010\Get-MailboxReport\GenAllReportsAndMail.ps1"

Open in new window

If I run the .bat file interactively from the Exchange Management Shell it executes perfectly. When it is run from the task scheduler the script runs but does not seem to execute the parameters after the Get-MailboxReport.ps1 on any of the lines.

The script which normally takes 90 minutes to complete finishes in 2 minutes without recording any errors but none of the .csv files are actually created.

Any ideas how I can make this work as a scheduled task?
hccaAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

coraxalCommented:
Assuming you're using the Task Scheduler on Win 2k8 or 7...I've been able to schedule tasks with the following settings:

Actions tab ->

Program/Script -> "C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe"
Add arguments (optional)  -> "C:\scripts\myscript.bat"
Start in (optional) -> "C:\scripts\"

The .bat file looks something like this:

Powershell -command " & { C:\scripts\thescript.ps1 } "
Simon Butler (Sembee)ConsultantCommented:
Does the script that you are running have this line at the top:

Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin

Try running it from a regular PowerShell session to see if it works.

Simon.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
hccaAuthor Commented:
Each of the powershell scripts involved have this line at the top. There are three scripts involved.

1. Get-MailboxReport.ps1 which requires command line switches when run.
2. GenAllReportsAndMail.ps1 which runs Get-MailboxReport.ps1 13 times with appropriate switches
3. GenAllReportAndMail.bat which is used by the task scheduler to run GenAllReportsAndMail.ps1

I can manually run the .bat file from a PowerShell session and it works perfectly. When it runs as a scheduled task the system thinks it successfully completed but it appears that the command switches for the 13 times that the Get-MailboxReport.ps1 script are not being run. Without those switches no files are generated.

Is this any more clear?
Creating Active Directory Users from a Text File

If your organization has a need to mass-create AD user accounts, watch this video to see how its done without the need for scripting or other unnecessary complexities.

Simon Butler (Sembee)ConsultantCommented:
When you setup the scheduled task, did you set it to run under a specific account?

Simon.
hccaAuthor Commented:
When I scheduled the task I was logged in as the domain administrator. I told the task to run even if not logged in and to run with highest privileged and supplied the password when prompted to finish the task creation.
basil2912Commented:
Hello,

Try to have Shell connect to exchange first:

powershell.exe -command ". '[exchange install folder]\v14\bin\remoteExchange.ps1';connect-exchangeserver -auto; [path]\GenAllReportAndMail.bat"
hccaAuthor Commented:
As indicated in my original post, I am doing this with this command in my bat file.

C:\Windows\System32\WindowsPowerShell\v1.0\powershell.exe -command ". 'C:\Program Files\Microsoft\Exchange Server\V14\bin\RemoteExchange.ps1'; Connect-ExchangeServer -auto; C:\Scripts\Exchange2010\Get-MailboxReport\GenAllReportsAndMail.ps1"
hccaAuthor Commented:
I actually found that the presence of this line:
Add-PSSnapin Microsoft.Exchange.Management.PowerShell.Admin
in the root script was breaking things. I'm not sure why but by starting there and manually running the script the error was seen and fixed.
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Powershell

From novice to tech pro — start learning today.