Re: DSPJOBJS(query on how to include all columns in my spool file) -- MIDRANGE-L

Murali

I see that this is for the Advanced Job Scheduler. I don't have that here, so I can't see what the command does.

Does the report have the data in some kind of wrapped layout? I.e., does it take more than one line?

Can you show us a few lines of the spooled output? Oh, is that what you've already done?

Are there options on the command (remember F9 to see all parameters) that control the kind of information that appears in the printout? (There is, I just want you to find it! <g>)

BTW, to get a little picky, when you say "report", I think "printout", whereas it seems you mean "display".

HTH

Vern

At 03:41 PM 7/16/2003 +0000, you wrote:

Hi all, Iam using command DSPJOBJS to find all jobs shceduled,the following report is generated(Figure1)...when i press F11 it is showing few more columns(Figure2)..but in my spool file iam getting columns as shown in the following table(Figure1) ,iam nt getting other columns (which i can get on the screen by pressing F11 as per Figure2)...how do i include those extra columns(Figure2 columsn ) in my spool file...hope iam clear in putting my question


Figure1.
----------------------------------------------------------------------
Job         Group       Grp               Schedule  Schedule
Name        Name        Seq   Status        Date      Time
Schedule

ADPBEGPRT   ADPBEGPRT     1   *READY       5/06/02    2:00
*DAILY
ADPCDSBS    ADPCDSBS      1   *READY       5/06/02   16:15
*DAILY
ADPCDSBSMX  ADPCDSBSMX    1   *READY       5/06/02    5:00
*DAILY
ADPCLRSES   ADPCLRSES     1   *READY       5/06/02   21:00
*DAILY
ADPENDPRT   ADPENDPRT     1   *READY       5/06/02   17:15
*DAILY
ADPPRTEJT   ADPPRTEJT     1   *READY       5/06/02    3:00
*DAILY
ADPSETUP    ADPSETUP      1   *READY       5/06/02   17:30
*CALENDAR
ADPSTARTUP  ADPSTARTUP    1   *DEPW       *NONE       0:00
*NONE
ADPTRCOUNT  ADPTRCOUNT    1   *READY      *NONE       0:00
*NONE
-----------------------------------------------------------------------

when i press F11 ,iam getting other useful columns like following...
Figure2:
--------------- Last run ------------------
  Date    Start   End   Elapsed  Completion

 3/08/02   2:57  16:08    81:12  *CANCELLED
 5/04/02  16:08   0:00     0:05  *SBMERROR
 5/04/02  16:08   0:00     0:01  *SBMERROR
 5/04/02  16:14  16:14     0:01  *NORMAL
 5/04/02  16:13  16:13     0:01  *NORMAL
 3/08/02   2:57  16:08    81:12  *CANCELLED
 5/04/02  16:13  16:14     0:01  *NORMAL
11/30/01  19:50  19:50     0:01  *NORMAL
11/30/01  19:59  19:59     0:01  *NORMAL
-----------------------------------------------------------------------

if i press F11 ,i still get few more coulmns,in my spool file i need to have all the columns how can i get all the coulmns in my spool file ...im transferring data from this spool file to my xlsheet....


Thanks so much,
Murali

___________________________________________________
Download the hottest & happening ringtones here!
OR SMS: Top tone to 7333
Click here now: http://sms.rediff.com/cgi-bin/ringtone/ringhome.pl


_______________________________________________
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.