Difference between revisions of "UC4"

From Vital Soft Wiki
Jump to: navigation, search
>Jeremyb
>Jeremyb
 
(4 intermediate revisions by the same user not shown)
Line 1: Line 1:
 
Vital Signs relies on nightly run UC4 jobs to extract the Core data which is warehoused and provided to the applications
 
Vital Signs relies on nightly run UC4 jobs to extract the Core data which is warehoused and provided to the applications
  
These jobs fall into two categories, daily and EOM.  The Daily is made up of 2 jobs, History and Membership Analysis.
+
These jobs fall into two categories, Daily and EOM.  The Daily is made up of 2 jobs, History and Membership Analysis. The EOM is made up of Membership Analysis.
 +
 
  
 
== Job Schedules ==
 
== Job Schedules ==
  
 
'''Daily'''
 
'''Daily'''
*History
+
History
**Run between 12:01 and 1am every day.
+
*Run between 12:01 and 1am every day.
*Membership Analysis
+
 
**Run prior to 5am
+
Membership Analysis
 +
*Run prior to 5am
 +
 
  
 
'''EOM'''
 
'''EOM'''
Line 17: Line 20:
  
 
== Daily Job Examples ==
 
== Daily Job Examples ==
 
'''HISTORY'''
 
  
 
<pre>
 
<pre>
##Run nightly- between 12:01 and 1 am.
+
    ## HIST DAILY
##Login as bolive
+
    ## Run nightly- between 12:01 and 1 am, including weekends
set -e
+
    ## Should be run prior to the MEMBERSHIP_ANALYSIS DAILY
cd /var/summit/spectrum/LIVE
+
    ## Login as bolive
/VSJOBS/JVSLOAD_HIST
+
    set -e
</pre>
+
    cd /var/summit/spectrum/LIVE
 +
    /VSJOBS/JVSLOAD_HIST
  
'''MEMBERSHIP ANALYSIS'''
+
 
+
    ## MEMBERSHIP_ANALYSIS DAILY
<pre>
+
    ## Run nightly – after JVSLOAD_HIST and prior to 5am
##Run nightly – after JVSLOAD_HIST and prior to 5am
+
    ## Do not run on days when the EOM job (see below) is scheduled
##Do not run on days when the EOM job (see below) is scheduled
+
    ## Login as bolive
##Login as bolive
+
    set -e
set -e
+
    cd /var/summit/spectrum/LIVE
cd /var/summit/spectrum/LIVE
+
    /VSJOBS/JVSLOAD_MBRSHLN
/VSJOBS/JVSLOAD_MBRSHLN
 
 
</pre>
 
</pre>
 
  
 +
''Note: There is no need to have your job plans pause and wait for completion of these jobs before
 +
continuing with the next step''
  
== Month End Example Job ==
 
  
'''MEMBERSHIP ANALYSIS'''
+
== EOM Job Example ==
  
 
<pre>
 
<pre>
##Run after report databases have been created
+
## MEMBERSHIP_ANALYSIS EOM
##Login as bolive
+
## Run after report databases have been created
 +
## Login as bolive
 
set -e
 
set -e
 
cd /var/summit/spectrum/LIVE
 
cd /var/summit/spectrum/LIVE
 
/VSJOBS/JVSLOAD_MBRSHLN eom &YYYYMMDD
 
/VSJOBS/JVSLOAD_MBRSHLN eom &YYYYMMDD
#Where &YYYYMMDD is a UC4 variable containing the last day of the month being closed
+
#Where &YYYYMMDD is a UC4 variable containing the last day of the month
 
</pre>
 
</pre>
 
  
 
''Note: There is no need to have your job plans pause and wait for completion of these jobs before
 
''Note: There is no need to have your job plans pause and wait for completion of these jobs before
 
continuing with the next step''
 
continuing with the next step''

Latest revision as of 22:42, 31 October 2012

Vital Signs relies on nightly run UC4 jobs to extract the Core data which is warehoused and provided to the applications

These jobs fall into two categories, Daily and EOM. The Daily is made up of 2 jobs, History and Membership Analysis. The EOM is made up of Membership Analysis.


Job Schedules

Daily History

  • Run between 12:01 and 1am every day.

Membership Analysis

  • Run prior to 5am


EOM

  • Membership Analysis
    • Run after report databases have been created


Daily Job Examples

    ## HIST DAILY
    ## Run nightly- between 12:01 and 1 am, including weekends
    ## Should be run prior to the MEMBERSHIP_ANALYSIS DAILY
    ## Login as bolive
    set -e
    cd /var/summit/spectrum/LIVE
    /VSJOBS/JVSLOAD_HIST

	
    ## MEMBERSHIP_ANALYSIS DAILY
    ## Run nightly – after JVSLOAD_HIST and prior to 5am
    ## Do not run on days when the EOM job (see below) is scheduled
    ## Login as bolive
    set -e
    cd /var/summit/spectrum/LIVE
    /VSJOBS/JVSLOAD_MBRSHLN

Note: There is no need to have your job plans pause and wait for completion of these jobs before continuing with the next step


EOM Job Example

## MEMBERSHIP_ANALYSIS EOM
## Run after report databases have been created
## Login as bolive
set -e
cd /var/summit/spectrum/LIVE
/VSJOBS/JVSLOAD_MBRSHLN eom &YYYYMMDD
#Where &YYYYMMDD is a UC4 variable containing the last day of the month

Note: There is no need to have your job plans pause and wait for completion of these jobs before continuing with the next step