FILE PROCESSING RUNS & JOB DEFINITIONS

child pages:

page index:

File Processing & Job Definition query with notes for some fields    
File Processing query with all fields and descriptive column names
File Processing fields in table
Job Definitions fields in table

links:

FILE PROCESSING RUNS & JOB DEFINITIONS Query

-- NOTE THAT THIS WILL ONLY FIND FILE PROCESSING RUNS FOR WHICH THERE IS AN ASSOCIATED JOB
-- IF THE OUTER JOIN OF FSFPRN IS CHANGED TO AN INNER JOIN
--
-- WITH NOTES
--
SELECT
TDEF.STTASKID AS TDEF_STTASKID__job_id ,
TDEF.STTDDESC AS TDEF_STTDDESC__job_description,
 TDEF.STTDMENEL AS TDEF_STTDMENEL__job_type ,
TDEF.STTDMSEC  AS TDEF_STTDMSEC__modification_security ,
TDEF.STTDPOSTEV AS TDEF_STTDPOSTEV_post_job_event,
 PROPS.STTDPID AS PROPS_STTDPID__Job_Property_ID,
PROPS.STTDPVAL AS PROP_STTDPVAL__Job_Property_Value,
FSRUNID AS FSRUNID__fpr_num,
FSFPRUN.FSRUNDESC AS FSRUNDESC__fpr_desc,
FSFPRUN.FSRUNFFID AS FSRUNFFID__file_format ,
FSFPRUN.FSRUNSCHEDID, -- statement to the right appears incorrect -> ID IN "ARTIVA SCHEDULE MANAGER"  <NJCODE> MAYBE NULL IF SECOND JOB FOR SCHEDULE?
FSFPRUN.FSRUNFREQ,  -- something strange abou this is stored; HOLDS D, 6, TH, ETC. WHICH    <NJFREQ>
FSFPRUN.FSRUNSTARTTIME,  -- MAY BE START TIME FROM A RUN OR FROM ARTIVA SCHEDULE MANAGER
FSFPRUN.FSRUNTASKID,  -- APPEARS TO BE THE FIRST JOB RUN BY THE SCHEDULE MANAGER ENTRY  (E.G. 66 FOR SCH ID 151, BUT WHERE IS SECOND JOB 83?? )
FSFPRUN.FSRUNLOCID,   --constant allowing location change without script change
FSFPRUN.FSRUNENDDTE,
FSFPRUN.A3RUNENDDTE,  --  END DATE IN FRP RUN PARAMATERS WINDOW
FSFPRUN.ZZRUNPARAM1, 
 FSFPRUN.ZZRUNPARAM2,
FSFPRUN.A3RUNFILENAME  --FILENAME OVERRIDE IN GUI
FROM
STTASKDEF TDEF
LEFT JOIN STTDPROPS_STTASKDEF PROPS ON PROPS.STTASKID = TDEF.STTASKID
RIGHT JOIN FSFPRUN ON FSFPRUN.FSRUNID = PROPS.STTDPVAL
WHERE
/*
TDEF.STTASKID = "323"
*/
(A3RUNFILENAME LIKE "%.A14%")
OR
FSRUNID = 725
/*
  AND  UPPER(FSFPRUN.FSRUNDESC) like '%RECALL%'
  OR  UPPER(FSFPRUN.FSRUNDESC) like '%RETURN%'
  OR  UPPER(FSFPRUN.FSRUNDESC) like '%NOTE%'
*/
/*and FSRUNID IS NULL  -- FIND ALL JOBS THAT DON'T DO ANYTHING WHEN USED WITH  STTDPID = "FPRUNID"*/
ORDER BY FSRUNID

File Processing Runs query with all fields and descriptive column names

--
-- ALL TABLE FIELDS
--
select
FSFPRUN.A3RUNCLSETID             AS desc_Client_Set
,FSFPRUN.A3RUNCLSETYN            AS desc_Client_in_Set
,FSFPRUN.A3RUNCLTID       AS desc_Client_ID
,FSFPRUN.A3RUNENDDTE             AS desc_End_Date
,FSFPRUN.A3RUNFILENAME           AS desc_Filename
,FSFPRUN.A3RUNSTDTE       AS desc_Start_Date
,FSFPRUN.A3RUNSTRUNID            AS desc_Statement_Run_ID
,FSFPRUN.A3RUNTESTMODE           AS desc_Run_Test_Mode
,FSFPRUN.FSFPBATCH        AS desc_Batch
,FSFPRUN.FSFPRUNAUDIT            AS desc_Audit_the_file_processing_run
,FSFPRUN.FSRUNATTREJTOEMAIL      AS desc_Attach_Reject_File_to_Email
,FSFPRUN.FSRUNBATCHTYPEID AS desc_Batch_type_ID
,FSFPRUN.FSRUNDESC        AS desc_Description
,FSFPRUN.FSRUNENDDTE             AS desc_End_Date
,FSFPRUN.FSRUNEXCPTSCRIPT AS desc_Schedule_Exception_Script
,FSFPRUN.FSRUNEXCSCRIPT          AS desc_Exception_Script
,FSFPRUN.FSRUNFFID        AS desc_File_format_ID
,FSFPRUN.FSRUNFREQ        AS desc_Schedule_of_Run_s_Frequency
,FSFPRUN.FSRUNGENERATED          AS desc_Is_run_generated
,FSFPRUN.FSRUNHRSBETW            AS desc_Hours_Between_Runs
,FSFPRUN.FSRUNID                 AS desc_ID
,FSFPRUN.FSRUNLOCID       AS desc_Location_ID
,FSFPRUN.FSRUNORIGRHFID          AS desc_Original_run_history_file_ID
,FSFPRUN.FSRUNPROCS       AS desc_Number_of_processes
,FSFPRUN.FSRUNREQTYPES           AS desc_Request_Types
,FSFPRUN.FSRUNSCHEDID            AS desc_Artiva_Scheduler_ID
,FSFPRUN.FSRUNSCHEDULE           AS desc_Schedule_this_run
,FSFPRUN.FSRUNSHAREDVALUE AS desc_Shared_var_namevalue_pairs
,FSFPRUN.FSRUNSTARTTIME          AS desc_Start_Time
,FSFPRUN.FSRUNSTATUS             AS desc_Status
,FSFPRUN.FSRUNTASKID             AS desc_Artiva_Task_ID
,FSFPRUN.FSRUNTIMEOUT            AS desc_Wait_For_File_Timeout
,FSFPRUN.FSRUNTYPE        AS desc_Type_importexport
,FSFPRUN.FSRUNUNTILTIM           AS desc_Rerun_until_this_time
,FSFPRUN.FSRUNVENDORS            AS desc_Vendors
,FSFPRUN.FSRUNVENDORSC           AS desc_Vendors_Calculated
,FSFPRUN.FSRUNVENDTYPE           AS desc_Vendor_type___agencyhost
,FSFPRUN.ZZRUNCHECKNUM           AS desc_Parameter_for_Check_Number
,FSFPRUN.ZZRUNCTRLTOTEMAIL AS desc_Control_Totals_Email_List
,FSFPRUN.ZZRUNPARAM1             AS desc_Custom_Run_Parameter_1
,FSFPRUN.ZZRUNPARAM2             AS desc_Custom_Run_Parameter_2
,FSFPRUN.ZZRUNPARAMDTE1          AS desc_Run_Parameter_Date
FROM
FSFPRUN
WHERE
FSFPRUN.FSRUNID > -1

IN TABLE File Processing Runs

Job Definitions In Table

last updated:    Wed 2022-07-20 6:28 AM