Join Query Took More then 2 Hour ,even we cancelled job job still working

Today or past 3 days i have observed my join query which is combination of ms-sql Source Views took sometime more then 2 hour because of this mine Azure SQL DB Reaches 90 % of cpu,please find the attached Profile…

One more query How i can Forcefully stopped Job as i saw even if i have cancelled job ,job state always showing running (32.0 KB)

@Vikash_Singh, did this run faster before? We’re you running this query alone, or were there other concurrent queries?

Please attach additional runs of the same query, then maybe we can get a better idea of what’s going on.

Yes this query run faster but not always ,this query itself run alone

please find attached Profile for Query which run sucssfully (18.8 KB)