COMMONWEALTH OF PENNSYLVANIA

DEPARTMENT OF PUBLIC WELFARE

INFORMATION TECHNOLOGY PROCEDURE

Name Of Procedure: / Number:

MCI Batch Operations Manual

/ PRO-IOS005
Domain: / Category:
Procedures / DIMO Server Application Procedures
Date Issued: / Issued By:
04/29/2005 /

DPW Bureau of Information Systems

Date Revised:
02/18/2008

General:

This document has been prepared after discussions between Deloitte and the Office of Information Systems pertaining to batch monitoring and notification.

This document was prepared as a result of conversations held with Deloitte Consulting members of the MCI Application and OIS Staff. The purpose of this document is to describe the details of Batch Operation processes, standards, naming conventions, and escalation procedures for the MCI batch jobs.

This document is structured to give an overview of batch operations for the eCIS application. This document should be used as reference information to assist Department of Public Welfare (DPW) Batch Operations on the eCIS batch strategy and approach.

Procedure:

MCI Batch Operations Manual.docPage 1 of 99

ECIS-PROD Schedule Requirements

*All jobs are classified by Tier to denote level of importance. See escalation procedures (Appendix A) below for a description

Job Id / Description / Job Dependencies (predecessor) / Dependent Jobs (successor) / Frequency / Run time (24H Format) / Expected Run Time length (in minutes) / Input File / Output File / Resolution /Escalation Process / ECIS On-call support instructions
ECSIMPSAR001 / The purpose of this job is to import the SAR flat file which is sent to:
\\pwisprdapp30\Apps\MCI\Application\Batch\PRD\Input
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CMR60D.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / N/A / ECSGENSAR002 / 5 days a week (m-f) / On demand / 5 / CMR60D.tgr / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSGENSAR002 / The purpose of this job is to generate data files that will be used by adobe server for merging with dynamic templates
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPSAR001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSIMPSAR001 / ECSSNDSAR003 / 5 days a week (m-f) / 5 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSSNDSAR003 / The purpose of this job is send the finish data files to the adobe server for processing.
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPSAR001. This is accomplished by a post event $job:ADD on the Finished OK event. . / ECSGENSAR002 / ECSCHKSAR004 / 5 days a week (m-f) / 5 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSCHKSAR004 / The purpose of this job is to check that all the data files have been merged by the adobe server and all PDFs have been created
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPSAR001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSSNDSAR003 / ECSCONSAR005 / 5 days a week (m-f) / 10 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSCONSAR005 / The purpose of this job is to concatenate the PDFs into groups of 100.
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPSAR001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSCHKSAR004 / ECSZIPSAR05B / 5 days a week (m-f) / 1 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSZIPSAR05B / The purpose of this job is to zip all the PDFs into a zip file.
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPSAR001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSCONSAR005 / ECSSNDSAR006 / 5 days a week (m-f) / 1 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSSNDSAR006 / The purpose of this job is to send the ZIP file to eGOV:
\\pwishbgwbm10\eGovernment\InData\DGSPRINT
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPSAR001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSZIPSAR05B / ECSGENADR001 / 5 days a week (m-f) / 1 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSIMPLIN001 / The purpose of this job is to import the LIN flat file which is sent to:
\\pwisprdapp30\Apps\MCI\Application\Batch\PRD\Input
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CMR60D.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / N/A / ECSGENLIN002 / 5 days a week (m-f) / On demand / 5 / CMR60D.tgr / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSGENLIN002 / The purpose of this job is to generate data files that will be used by adobe server for merging with dynamic templates
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPLIN001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSIMPLIN001 / ECSSNDLIN003 / 5 days a week (m-f) / 5 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSSNDLIN003 / The purpose of this job is send the finish data files to the adobe server for processing.
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPLIN001. This is accomplished by a post event $job:ADD on the Finished OK event. . / ECSGENLIN002 / ECSCHKLIN004 / 5 days a week (m-f) / 5 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSCHKLIN004 / The purpose of this job is to check that all the data files have been merged by the adobe server and all PDFs have been created
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPLIN001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSSNDLIN003 / ECSCONLIN005 / 5 days a week (m-f) / 10 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSCONLIN005 / The purpose of this job is to concatenate the PDFs into groups of 100.
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPLIN001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSCHKLIN004 / ECSZIPLIN05B / 5 days a week (m-f) / 1 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSZIPLIN05B / The purpose of this job is to zip all the PDFs into a zip file.
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPLIN001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSCONLIN005 / ECSSNDLIN006 / 5 days a week (m-f) / 1 / None / Log file / Tier1: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSSNDLIN006 / The purpose of this job is to send the ZIP file to eGOV:
\\pwishbgwbm10\eGovernment\InData\DGSPRINT
This job is only added to the ECIS- PROD schedule upon the successful completion of ECSIMPLIN001. This is accomplished by a post event $job:ADD on the Finished OK event. / ECSZIPLIN05B / ECSGENADR001 / 5 days a week (m-f) / 1 / None / Log file / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSGENADR001 / The purpose of this job is to create the Outgoing and Return address files used by the DGS inserter / REFSYNC (from WEBCMPROD schedule) / ECSSNDADR002 / 5 days a week (m-f) / 05:00 / 1 / None / Log file / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSSNDADR002 / The purpose of this job is to send the address files to the inserter machine at DGS / ECSGENADR001 / 5 days a week (m-f) / 1 / None / Log file / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact:
Raj Gundala
717 215 8724
Or backup:
Matt Schnure
717 982 3361
ECSWDAGAT001 / The purpose of this job is to calculate the number of days passed since the creation of a work item for all the open activities and update the summary counts in the summary table for each user / None / None / 7 days a week / 05.00 / 50 / None / Log file / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead
ECSWDCCLD001 / The purpose of this job is to process the mainframe file containing the data on the case to caseload changes happened during the day and to update the eCIS table with the information.
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (AIS06D01.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / None / ECSWDCSAT001 / 5 days a week (m-f) / On Demand / 10 min / Ais06D01.tgr / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error contact track lead
ECSWDCSAT001 / The purpose of this job is to process the mainframe file containing the new alerts and populate the data in eCIS alerts table and create the dashboard work item assigning it to the user.
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CCM72E01.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / ECSWDCCLD001
ECSWDDSAT001 / ECSWDCSAT002
ECSWDCSAT003 / 5 days a week (m-f) / On Demand / ccm72e01.tgr / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead
ECSWDCSAT002 / The purpose of this job is to process the mainframe file containing the monthly alerts and populate the data in eCIS alerts table and create the dashboard work item assigning it to the user.
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CCM04M05.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / ECSWDCSAT001 / First full week end of month / On Demand / CCM04M05.tgr / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead
ECSWDCSAT003 / The purpose of this job is to process the mainframe file containing the quarterly alerts and populate the data in eCIS alerts table and create the dashboard work item assigning it to the user.
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CCM04Q05.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / ECSWDCSAT001 / Ad hoc
(Every Quarter) / On Demand / CCM04Q05.tgr / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead
ECSWDCSAT004 / The purpose of this job is to process the mainframe file containing the yearly alerts and populate the data in eCIS alerts table and create the dashboard work item assigning it to the user.
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CCM04Y05.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / ECSWDDSAT001 / Ad hoc
(Every Year) / On Demand / CCM04Y05.tgr / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDDSAT004 / The purpose of this job is to process the mainframe file containing the alert disposal triggers and dispose the alerts in eCIS tables and mark them as complete in work load dashboard.
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CCM73E01.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / ECSWDCSAT001
ECSWDCSAT004 / 5 days a week (m-f) / On Demand / CCM73E01.tgr / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDMDST001 / The purpose of this job is to update the Staff table is eCIS marking all the staff as unavailable and setting their work load count to zero. / None / None / 7 Days / 12.05 / 3 min / None / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDPACT001 / The purpose of this job is to delete all the completed activities from eCIS tables according to purge policy. / ECSWDPALT001
ECSWDPALT002
(Ignore exit code) / ECSWDPALT001
(conflict dependency – Will not start if ECSWDPALT001 is running)
ECSWDPCON001 / 7 days / 19.00 / 15 min / None / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDPALT001 / The purpose of the job is to purge completed alerts and incomplete alerts according to the purge policy / ECSWDPACT001
(conflict dependency – Will not start ECSWDPACT001
If this job is running) / ECSWDPACT001
ECSWDPALT002
(Ignore exit codes) / 7 days / 18.00 / 10 min / None / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDPALT002 / The purpose of the job is to purge completed alerts and incomplete alerts according to the purge policy(monthly) / ECSWDPALT001
(Ignore exit code) / ECSWDPACT001
(Ignore exit codes) / Ad hoc
(First full week end of the month) / 18.00 / 10 min / None / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDPCHR001 / The purpose of the job is to purge the inactive characteristics not associated to any staff or activities according to the purge policy. / ECSWDPSTF001
(Ignore exit code) / Ad hoc
(First full week end of the month) / 21.00 / 10 min / None / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDPCON001 / The purpose of the job is to purge the inactive configurations not associated activities according to the purge policy. / ECSWDPACT001
(Ignore exit code) / ECSWDPSTF001
(Ignore exit code) / 7 days / 20.00 / 10 min / None / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDPSTF001 / The purpose of the job is to purge the inactive staff not associated to any activity or configurations. / ECSWDPCON001
(Ignore exit code) / ECSWDPCHR001
(Ignore exit code) / Ad hoc
(First full week end of the month) / 20.30 / 10 min / None / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDREQU001 / The purpose of the job is to resubmit the failed assignments from the audit assignment table till the threshold error value is reached. Also this job achieve the data from the audit assignment table to history table, purge from the history table according to the archival and purge policy. / None / None / 7 days / 22.00 / 20 min / None / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDRSYN001 / The purpose of this job is to process the mainframe file containing the TTYP reference table data and syncs the MCI ITASCA reference table.
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CSR40MTTYP.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / None / None / 5 days a week (m-f) / On Demand / CSR40TTYPM.tgr / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.
ECSWDSEAT001 / The purpose of this job is to process the mainframe file containing the new security alerts and populate the data in eCIS alerts table and create the dashboard work item assigning it to the user.
This job is only added to the ECIS-PROD schedule upon the arrival of the trigger file (CCM02D02.tgr) in the input folder. This is accomplished by a $job:ADD event from the Argus FileWatcher. / None / None / 5 days a week (m-f) / On Demand / CCM02D02.tgr / Log File / Tier3: The escalation procedures described below should be followed. / Check the log and determine the reason for failure. If the job stopped abruptly, ask scheduling to restart it again. If the jobs encountered a different error, contact track lead.

MCI Batch Operations Manual.docPage 1 of 99