RE: Change ODBC Job to run in own subsystem and change priority

Elvis,

That was exactly what I was looking for.  I just wanted to change it for a
specific user/server not all ODBC clients.  Thank you.  I really like the
newsletters and have signed up for them.

John Bresina Jr
Sr Server Engineer - Midrange Team
Allianz Life of North America
5701 Golden Hills Drive
Minneapolis, Mn 55416
763 582 6761


                                                                           
             "Elvis Budimlic"                                              
             <ebudimlic@center                                             
             fieldtechnology.c                                          To 
             om>                       "'Midrange Systems Technical        
             Sent by:                  Discussion'"                        
             midrange-l-bounce         <midrange-l@xxxxxxxxxxxx>           
             s@xxxxxxxxxxxx                                             cc 
                                                                           
                                                                   Subject 
             08/18/2005 01:34          RE: Change ODBC Job to run in own   
             PM                        subsystem and change priority       
                                                                           
                                                                           
             Please respond to                                             
             Midrange Systems                                              
                 Technical                                                 
                Discussion                                                 
             <midrange-l@midra                                             
                 nge.com>                                                  
                                                                           
                                                                           




John,
we at Centerfield heard this question number of times and discussed it in
our newsletters.
Checkout page 4 of August's newsletter:

http://www.centerfieldtechnology.com/publications/archive/August%202005%20Ne

wsletter.pdf

as well as page 3 of April's newsletter:

http://www.centerfieldtechnology.com/publications/archive/April%202005%20CTI

Newsletter%20.pdf

If you like the newsletters, sign up for them.

Elvis

-----Original Message-----
 Subject: Change ODBC Job to run in own subsystem and change priority

We currently have several ODBC jobs that hit our system, one in particular
is for our reporting team and it runs with an id of WFIIGRPT.  These
reporting jobs run a long time and consume system resources.    Is it
possible to force this QZDASONIT job to run under a different subsystem and
also change it run priority from 20 to 50.


John Bresina Jr
Sr Server Engineer - Midrange Team
Allianz Life of North America
5701 Golden Hills Drive
Minneapolis, Mn 55416
763 582 6761



--
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.




-----------------------------------------
CONFIDENTIALITY NOTICE:  The information in this message, and any files
transmitted with it, is confidential, may be legally privileged, and
intended only for the use of the individual(s) named above.  Be aware
that the use of any confidential or personal information may be
restricted by state and federal privacy laws.  If you are not the
intended recipient, do not further disseminate this message.  If this
message was received in error, please notify the sender and delete it.