RE: Number of SQL jobs -- MIDRANGE-L

Subject: RE: Number of SQL jobs
From: "DeLong, Eric" <EDeLong@xxxxxxxxxxxxxxx>
Date: Tue, 18 Dec 2012 16:28:46 +0000
List-archive: <http://archive.midrange.com/midrange-l>
List-help: <mailto:midrange-l-request@midrange.com?subject=help>
List-id: Midrange Systems Technical Discussion <midrange-l.midrange.com>
List-post: <mailto:midrange-l@midrange.com>
List-subscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=subscribe>
List-unsubscribe: <http://lists.midrange.com/mailman/listinfo/midrange-l>, <mailto:midrange-l-request@midrange.com?subject=unsubscribe>

Hi John,

Sounds like you need to setup a DB Monitor job. This is one of the diagnostic functions that are exposed from System i Navigator.

It also sounds like you're trying to obtain this information for a prior event, and you wonder what "SQL jobs" were running at that time. I'm not sure that there's much to be done to produce those details without having a DB monitor running...

-Eric DeLong

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx [mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of John Mathew
Sent: Monday, December 17, 2012 9:49 PM
To: Midrange Systems Technical Discussion
Subject: Number of SQL jobs

Hi,

How to check SQL jobs that were running in system.

Is there any command or something to check.

Please advise.

John

This mailing list archive is Copyright 1997-2026 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.