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.
Query XMETA for bulk job statuses
Moderators: chulett, rschirm, roy
Query XMETA for bulk job statuses
iShoreETL
-
- Participant
- Posts: 54607
- Joined: Wed Oct 23, 2002 10:52 pm
- Location: Sydney, Australia
- Contact:
Re: Query XMETA for bulk job statuses
What makes you think that this is the case? Can you provide a reference?iShoreETL wrote:I am aware this information is stored in XMETA database (which we have in SQL Server).
Last time I looked (version 8.7) job status was still stored in RT_STATUSnnn in the local (project) repository.
IBM Software Services Group
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Any contribution to this forum is my own opinion and does not necessarily reflect any position that IBM may hold.
Re: Query XMETA for bulk job statuses
ok, your going to have to forgive me on that then...It appears I was misinformed.
going back into the books.
Thanks.
going back into the books.
Thanks.
iShoreETL