Query XMETA for bulk job statuses

[iShoreETL]

Greetings DSX'ers....

I know that DSJob.exe gives us a XML based status of a job.
Job Name, Start Date, End Date, Status.

I am aware this information is stored in XMETA database (which we have in SQL Server).

I do not want to start querying there without knowing what I'm doing.

Has anyone created a query that will give you the same data, but altogether as a recordset? we have over 500 PRL/SRVR/SEQ jobs and calling DSJob.exe is very inefficient. Can we do it via SQL Query against XMETA? and if so, how?

thanks.

[ray.wurlod]

I am aware this information is stored in XMETA database (which we have in SQL Server).

What makes you think that this is the case? Can you provide a reference?

Last time I looked (version 8.7) job status was still stored in RT_STATUSnnn in the local (project) repository.

[iShoreETL]

ok, your going to have to forgive me on that then...It appears I was misinformed.

going back into the books.
Thanks.