Re: MVBase Spooler Help

David Ehrhart wrote: 
Hi Group,

I have a question about the Pick (in this case MVBase) spooler.

I (potentially) will have multiple clients on one MVBase machine. Trying to track spooler entries is difficult enough... however, when they run the Month-End process, it produces close to 30 Hold Entries. Having 2 or 3 or 4 clients running different month-end will get confusing -- if not impossible -- to figure out's who's is whose.

I'm sure there may be 3rd party spooler software out there and I'd love to hear about it.

What I thought that might be interesting (as a possible solution) is to change the user account (temporarily). If I could do this, then instead of seeing the USER who generated the hold entry when using either a LISTPEQS or SP-LISTQ, it would show a "Company: Report Name" (something like) - ABC: AR Aging; OR XYZ: AP Forecast.

I've tried the Charge-To (that give the user to be User*ABC: AR Aging) but when I generated the hold entry it kept just the user. I've also tried messing around with the ACC data... that didn't work either.

So, the question is... is there a quick (and easy... short of LOGGING to for each spooler entry) to change the user name (retain the old one) with a TCL command, Basic command, or User Exit PRIOR to generating a Hold Entry... and then change it back?

Thanks,

David



From the sounds of it, you have everyone running in the same account. Why don't you create a Q account for each client - that way each client will appear to have their own account while utilising all the programs of the base account, and their spooler jobs will be allocated to the individual Q accounts.

For example, the real account name is REALACCOUNT. Create an entry in the SYSTEM file in the SYSPROG account like:

	CLIENT1
001	Q
002	REALACCOUNT
003
004
005
006
007
008	SYS2         <== or whatever privilege is appropriate
009	L
010	10

with equivalent entries for CLIENT2, CLIENT3 etc.

Each client will then log on as CLIENT1 (or CLIENT2), and any spooler entries will be identified as belonging to account CLIENT1 (or CLIENT2 etc).

Does this help?

Cheers,


Brian Speirs
--
***************************************************
Brian Speirs
h: (04) 479 9032  c: (021) 265 5906
e: brian at rushflat dot co dot nz
.

Relevant Pages

  • Re: MVBase Spooler Help
    ... IF there was an easy way to change the Account Name on the "fly" ... Pick is the spooler... ... thanks for all the response... ... >>There's a limited about of space for each form queue entry, ...
    (comp.databases.pick)
  • Re: Take Over Practices
    ... didn't steal an account as much as you lost an account! ... customer is unhappy with services provided. ... takeover clients from ADT and the other mass market "paper flippers"...... ...
    (alt.security.alarms)
  • Re: Relationships
    ... This is my first experience with building a database, ... >>every account is in the process of receiving or delivering assets. ... > multiple clients and individual clients within an account might have ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Please Help - User Profile Problems???
    ... Can the same user log in successfully to an NT workstation? ... > I have an SBS4.5 network with mainly NT4w clients. ... > means of a single general account that is enabled through Proxy Server so ...
    (microsoft.public.windowsxp.security_admin)
  • Re: Random "computer account was not found" broken profiles Server
    ... It could be connectivity, DNS, computer account password, secure ... Speaking of connectivity, "ping" alone doesn't count. ... Make sure that your clients use only their local DNS Server. ...
    (microsoft.public.windows.server.active_directory)