Can't pass variable into Copy-DbaAgentJob from array

[simon-smart]

Hi, I'm pretty new to PowerShell so apologies if this is a really simple problem! but I am trying to run the Copy-DbaAgentJob cmdlet within a ForEach loop of agent jobs that have changed recently, but I am struggling to get the variable for the -Job parameter to pass into the cmdlet. Here is my basic script:

$Query = @"
SELECT name FROM ##Jobs
"@
$Jobs = Invoke-SqlCmd -ServerInstance myserver -Database master -Query $Query;
$Jobs
ForEach ($i in $Jobs)
{
Copy-DbaAgentJob -Source myserver -Destination myotherserver -Job $i -Force -Verbose;
}

The idea being that the ##Jobs temp table in SQL is populated with a list of applicable agent jobs. My test case has 1 job - "dbatools_testJob" in the list. Returning the $Jobs variable shows the variable has been successfully populated,

PS C:\Windows\system32> C:\Program Files\WindowsPowerShell\Scripts\dbaTest_3.ps1

name            
----            
DBATools_testJob

However the cmdlet does not run. What's odd is if i hard-code the job name into the cmdlet, it will work, so the ForEach loops is operating fine, but it won't pass the $i variable and I can't see why.

Hard-coded -Job parameter

$Query = @"
SELECT name FROM ##Jobs
"@
$Jobs = Invoke-SqlCmd -ServerInstance myserver -Database master -Query $Query;
$Jobs
ForEach ($i in $Jobs)
{
Copy-DbaAgentJob -Source myserver -Destination myotherserver -Job dbatools_testJob -Force -Verbose;
}

Returns

PS C:\Windows\system32> C:\Program Files\WindowsPowerShell\Scripts\dbaTest_3.ps1

VERBOSE: [15:32:36][Copy-DbaAgentJob] Working on job: DBATools_testJob
VERBOSE: Performing the operation "Dropping job DBATools_testJob and recreating" on target "myotherserver".
VERBOSE: [15:32:37][Copy-DbaAgentJob] Dropping Job DBATools_testJob
VERBOSE: Performing the operation "Creating Job DBATools_testJob" on target "myotherserver".
VERBOSE: [15:32:37][Copy-DbaAgentJob] Copying Job DBATools_testJob
VERBOSE: Performing the operation "Reporting status of migration for DBATools_testJob" on target "myotherserver".
name            
----            
DBATools_testJob
DBATools_testJob

If anyone has any advice it would be greatly appreciated. Thanks!