declare @pss varchar(max) = '$connection = New-Object System.Data.SqlClient.SqlConnection("Data Source=%server%;Integrated Security=SSPI;Initial Catalog=%database%;");

$c1 = $connection.CreateCommand(); $c1.CommandText = "set showplan_xml on;";
$c2 = $connection.CreateCommand(); $c2.CommandText = "%query%";

$connection.Open();

$result = $c1.ExecuteNonQuery();
$r = $c2.ExecuteXmlReader();
$result = $r.Read();
$r.ReadOuterXml();
';

declare @query varchar(max) = 'select * from msdb..sysjobs a join msdb..sysjobsteps b on b.job_id = a.job_id';

set
 @pss = replace(replace(replace(replace(replace(@pss, '%server%', @@servername), '%database%', db_name()), '%query%', @query), nchar(10), ' '), nchar(13), ' ');

declare @command varchar(8000) = replace('powershell -command "%command%"', '%command%', replace(@pss, '"', '\"'));

declare @t table (s nvarchar(max));
insert into @t
 (s)
 exec xp_cmdshell @command;

declare @plan xml;
select
 @plan = cast(string_agg(s, '') as xml)
from
 @t
where
 s is not null;

with xmlnamespaces(default 'http://schemas.microsoft.com/sqlserver/2004/07/showplan')
select distinct
 t.n.value('@Database', 'sysname'),
 t.n.value('@Schema', 'sysname'),
 t.n.value('@Table', 'sysname')
from
 @plan.nodes('//Object') t(n);