The first two systems I worked with using InterSystems technology were a PDP-11 running M11+ and a VAX 11/750 running M/VX. Too many years ago to count! 😊
Since then I've used most, if not all, InterSystems products up to IRIS and HealthShare today.
I'm Italian living in Switzerland and I work as Senior Consultant at GAIVOTA consultin SA, we provide professional services for InterSystems and other technologies.
Curiosity: apart from DC, I don't have ANY social account! 😁
I strongly discourage the use of embedded sql, it has many disadvantages.
Sorry Theo but I don't agree at all.
The differences (disadvantageous or not) between Embedded SQL and Dynamic Queries have evaporated since few years now, please have a look to this article from @Benjamin De Boe :
New in 2020.1: the Universal Query Cache
In general, I advice to use the query type (Embedded vs. Dynamic) that best fit in given code pattern, for example Embedded SQL is very convenient for query that returns 1 row.
Or maybe you have other issues with Embedded SQL?
I think you are mixing hosts (production component) and jobs.
A host can be enabled or disabled, when a host is enabled there are a number (PoolSize) of jobs and each job has a status.
You can view/list the status/details of production jobs in the Management portal Interoperability -> Monitor -> Jobs.
You already know how to get if an host is enabled/disabled, to get the status of all jobs you can use the query Enumerate in the Ens.Job class, to test it:
Set rs=##class(Ens.Job).EnumerateFunc()
Do rs.%Display()
If the header is called "AUTHORIZATION", then use:
Set authHeader = %request.GetCgiEnv("AUTHORIZATION")