Re: Sessions count?

Job notification exit points [as I infer] can be used to log start and stop timestamps [and other stuff]. Logged to a database file, a query of the output could count the jobs that spanned a specific [period of] time.

http://publib.boulder.ibm.com/infocenter/iseries/v5r4/index.jsp?topic=/apis/xjobntfy.htm

Although job accounting might be able to as well, I think its output is only at the end of a job, which means an inquiry of the DSPJRN output would have to await the end of any job that started prior to the [period of time] which is of interest.

Regards, Chuck
-- All comments provided "as is" with no warranties of any kind whatsoever and may not represent positions, strategies, nor views of my employer

Karl wrote:
Is there a way to find out how many sessions were open (or users were connected) at a specific time, for example, 2pm?
.

Relevant Pages

  • Re: Database Alternative
    ... > Its in a beta state and I want to inform you some test ... Hi bumerang, ... A query for one indexed object in 10,000 objects takes 1.1 seconds. ... The indexed database file has a size of 470kB. ...
    (microsoft.public.dotnet.framework.compactframework)
  • Re: would a Stored Procedure help
    ... > timestamps in the last hour. ... you want to hard-code the date in the query. ... exceptions to the rule of using parameter markers for your queries. ... will give SQL Server the maximum amount of statistical information about how ...
    (microsoft.public.sqlserver.programming)
  • Re: Make a report show content from an external Database
    ... You can create a query or modify the sql of a query to something like: ... This would allow you to create a record source for your report. ... So i have a database file with forms ... Dim qdf As QueryDef ...
    (microsoft.public.access.reports)
  • Re: Mail Merge query results with Office 2002
    ... I changed the select queries to a make table queries (user input ... Jerry M. Gartner ... I may end up doing a make table query - since only tables are there. ... Then choose your database file. ...
    (microsoft.public.access.queries)
  • Re: Mail Merge query results with Office 2002
    ... sure why the queries aren't available but they aren't. ... database file, but the default file type is a Word document. ... Your next choice is to select the Table or Query containing the ...
    (microsoft.public.access.queries)