×
The internal search function is temporarily non-functional. The current search engine is no longer viable and we are researching alternatives.
As a stop gap measure, we are using Google's custom search engine service.
If you know of an easy to use, open source, search engine ... please contact support@midrange.com.
(V5R4M0)
Given that you have full access to all of the components available through
Navigator:
1) Open Iseries Navigator
2) Click Work management
3) click Active Jobs or Server Jobs
4) Scroll down to a Qzdasoinit job
5) Right click on the job
6) Take the Details option
7) There is a Last SQL Statement Option that should display the SQL
statement.
;-)
-sjl
"Graves, Chuck" wrote in message
news:mailman.3028.1374000434.9013.midrange-l@xxxxxxxxxxxx...
I have a SQL server job, running a store procedure which does a SQL select
from my iSeries data. The job has suddenly gone from 1.5 minutes execution
time to NEVER finishing...runs forever.
How/Where can I see this job on the iSeries?
[Rodda Paint Company!] Chuck Graves
Director of Information Systems
Rodda Paint Co.<
http://www.roddapaint.com>
6107 N. Marine Drive
Portland, Oregon 97203
(503) 737-6042
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact
[javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.