Error while using sqlcmd with Start-Job in PowerShell

Question

When I'm executing this command in PowerShell, everything works fine:

sqlcmd -S dwh -i ".\script.sql" -o ".\log.txt"

However, when I'd like to set up several jobs, the following command doesn't work:

Start-Job -Name TestSqlCmd -ScriptBlock {sqlcmd -S dwh -i ".\script.sql" -o ".\log.txt"}

I got the following error:

Sqlcmd: Error: Error occurred while opening or operating on file .\script.sql (Reason: The system cannot find the path specified).
    + CategoryInfo          : NotSpecified: (Sqlcmd: Error: ...ath specified).:String) [], RemoteException
    + FullyQualifiedErrorId : NativeCommandError
    + PSComputerName        : localhost

Could you help me with that issue please?

deralbert · Accepted Answer · 2020-08-11 01:54:45Z

2

Whenever you start a job, the script block inside that job actually runs in a new PS session. Therefore, you are nor longer cd'ed into the same path, but you can do the following to fix that:

Start-Job -Name TestSqlCmd -ScriptBlock {
    Param(
        $path
    )
    echo "$path\script.sql" 
    echo "$path\log.txt"
} -ArgumentList (Get-Location).Path

Or just add a full path in the script-block itself.

edited Aug 11, 2020 at 1:54

deralbert

1,1012 gold badges18 silver badges40 bronze badges

answered Apr 6, 2020 at 14:41

Roque Sosa

5834 silver badges22 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

js2010 · Accepted Answer · 2020-04-06 15:29:48Z

0

Powershell 7 has a -workingdirectory parameter too. Actually it looks like start-job or start-threadjob in ps 7 respects the current directory anyway.

answered Apr 6, 2020 at 15:29

js2010

28.3k6 gold badges82 silver badges88 bronze badges

Collectives™ on Stack Overflow

Error while using sqlcmd with Start-Job in PowerShell

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related