Difference between revisions of "Running HPUX Jobs Manually"

From Vital Soft Wiki
Jump to: navigation, search
>Kevint
>Jeremyb
Line 68: Line 68:
  
 
  Syntax:
 
  Syntax:
  /VSJOBS/JVSRELOAD GROUPNAME [REQDATE]
+
  /VSJOBS/JVSRELOAD GROUPNAME [REQDATE] [LOAD=YES] [PRINT=FREQUENCY]
  
 
  Separate script for each Credit Union
 
  Separate script for each Credit Union
Line 74: Line 74:
 
  This script must login as either 'bolive', 'botest' or 'bocu##'.
 
  This script must login as either 'bolive', 'botest' or 'bocu##'.
 
  Based on LOGNAME, the extract will use the appropriate profile.
 
  Based on LOGNAME, the extract will use the appropriate profile.
 +
 +
Examples
 +
# Run the Daily Reports for the Membership_Analysis_by_ACCOUNT for 20121131
 +
/VSJOBS/JVSRELOAD Membership_Analysis_by_ACCOUNT 20121131 LOAD=NO PRINT=DAILY
 
</pre>
 
</pre>

Revision as of 17:06, 6 December 2012

Summary

The following information is a detailed overview of each of the Vital Signs Jobs and their supported parameters.


JVSLOAD_MBRSHLN

This job extracts information from member-file, share-file, loan-file and loanapp.

  Syntax:
  /VSJOBS/JVSLOAD_MBRSHLN [eom | restore] [YYYYMMDD]"

  - eom        Process eom, use the report database."
               o uses the vsdata_eom profile in vsrvtcp.ini
			   
  - restore    Restoring data from backup, use the specified date.
               o uses the vsdata_restore profile in vsrvtcp.ini
               o data is extracted and transfered to Vital Signs,
                 however, no documents are refreshed.
				 
  - YYYYMMDD   The as-of-date assigned to the extracted data.
               o If not eom and extract is run before 6:00 am,
                 default is previous day.
               o If not eom and extract is run after 6:00 am,
                 default is current day.
               o If eom and today is last day of the month,
                 use current date.
               o If eom and today is not the last day of the month,
                 use previous month-end.
               o If restore, the date parm is required and should
                 be the effective date of the backup being restored.

 This script must login as either 'botest', 'bolive' or 'bocu##' or 'boi###'.
 Based on LOGNAME, the extract will use the appropriate vital signs profile.

JVSLOAD_HIST

This job extract information from sh-history and ln-history.

  Syntax:
  /VSJOBS/JVSLOAD_HIST [YYYYMMDD] [CMNDFILE=1] [TYPE={HIST|DC|ALL}]
                 [DAYS=num_days] [LOOP=num_loops]

  - CMNDFILE=1 Force download of the command file.

  - YYYYMMDD   Extracts HIST records starting with the specified date.

  - TYPE=HIST  Extracts history transactions (all types)
        =DC    Extracts binary data change records only.
        =ALL   Extracts history transactions and data change records.

  - DAYS=num   The number of days to extract in a single find.
               Default is one day.

  -LOOPS=num   The number of loops to make in a single run of the job.
               Default is 30 loops.
               Total dates extracted is DAYS * LOOPS. The maximum date
               is determined by the current CU Business (Open) date.

This script must login as either 'botest', 'bolive' or 'bocu##' or 'boi###'.
Based on LOGNAME, the extract will use the appropriate vital signs profile.

JVSRELOAD

This job bypasses the HPUX extracts and reloads the data on the Windows host.


 Syntax:
 /VSJOBS/JVSRELOAD GROUPNAME [REQDATE] [LOAD=YES] [PRINT=FREQUENCY]

 Separate script for each Credit Union

 This script must login as either 'bolive', 'botest' or 'bocu##'.
 Based on LOGNAME, the extract will use the appropriate profile.

 Examples
 # Run the Daily Reports for the Membership_Analysis_by_ACCOUNT for 20121131
 /VSJOBS/JVSRELOAD Membership_Analysis_by_ACCOUNT 20121131 LOAD=NO PRINT=DAILY