{"text_format":"1","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","FINANCIAL_PROCESSING"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Instructions","index":0,"n_rows":49,"n_cols":2,"rows_kept":49,"cut":false,"hidden":false,"merged":[]}
[]
[null,"Instructions:"]
[]
[]
[null,"In the scheduler"]
[null,"    1)  In the Define section, Download the schedule "]
[null,"    2)  Right click on schedule and \"Save As\""]
[null,"    3)  Save file in directory below"]
[null,"                C:\\temp\\"]
[]
[null,"In Execl"]
[null,"    1) Open the spreadsheet. "]
[null,"    2) If a yellow warning message pops up select the \"Enable Content\" to enable the macro."]
[null,"    3) Run the macro by going to the view tab, Click the Macros icon, highlight \"GetJobData\" and click Run"]
[null,"    4)  When prompted for the schedule name put in the schedule name"]
[null,"                Do not include the .xml extension"]
[]
[]
[null,"Notes:"]
[null,"    1)  In older Excel versions the Macro button is in a different menu."]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[]
[null," "]

{"sheet":"FINANCIAL_PROCESSING","index":1,"n_rows":43,"n_cols":30,"rows_kept":43,"cut":false,"hidden":false,"merged":[]}
["Jobname","Job Type","Run Days","NoRun","Start Time","Dueout Start","Dueout End","Min Time","Max Time","Script Name","Arguments","Successors","Rel Cond","Resource Name","Res Qty","Agent name","Userid","Tag","SubAppl","Held?","Req?","Cond?","File or Data Set Trigger Name","FT Type","FTP Server","FTP Direction","FTP Port","FTP Rmt File","FTP Local File","JCL"]
["ARCHIVE_CHICAGO","nt_job","Monday\nWednesday\nFriday","holidays",null,null,null,null,null,"C:\\Financials\\scripts\\Archive.bat","Chicago","Backup_Final","NORMAL",null,null,"ARCHIVE_SERVER"]
["ARCHIVE_DALLAS","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Archive.bat","Dallas","Backup_Final","NORMAL",null,null,"ARCHIVE_SERVER"]
["Archive_Files_1","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Archive.bat","Archive Garbage here","ARCHIVE_DALLAS\nARCHIVE_NY\nARCHIVE_LA\nARCHIVE_CHICAGO","NORMAL\nNORMAL\nNORMAL\nNORMAL",null,null,"ARCHIVE_SERVER"]
["ARCHIVE_LA","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Archive.bat","LA","Backup_Final","NORMAL",null,null,"ARCHIVE_SERVER"]
["ARCHIVE_NY","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Archive.bat","NY","Backup_Final","NORMAL",null,null,"ARCHIVE_SERVER"]
["Backup_Files","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Backup_Files.bat","Backup1","Process_Transactions","NORMAL",null,null,"BACKUP_SERVER"]
["Backup_Final","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Archive.bat","Final",null,null,null,null,"ARCHIVE_SERVER"]
["DSTRIG_Chicago","dst_job"," DAILY"," ",null,null,null,null,null,null,null,"Upload_Chicago","NORMAL",null,null,"FINANCIAL_SERVER","USER1",null,null,null,null,null,"PROSYS. TEST.DATASET"]
["FileMonitor_Dallas","filemon_job"," DAILY"," ",null,null,null,null,"120 Mins",null,null,"Upload_Dallas","NORMAL",null,null,"FINANCIAL_SERVER",null,null,null,null,null,null,"C:\\TestLocation\\abc\\financial files\\file_Dallas.txt","Create"]
["FileMonitor_Final_1","filemon_job"," DAILY"," ",null,null,null,null,"120 Mins",null,null,"FTP_Financial_3","NORMAL",null,null,"FINANCIAL_SERVER",null,null,null,null,null,null,"C:\\TestLocation\\abc\\financial files\\file_WAS_THERE.txt","Create"]
["FileMonitor_Final_2","filemon_job"," DAILY"," ",null,null,null,null,"120 Mins",null,null,"FTP_Financial_4","NORMAL",null,null,"FINANCIAL_SERVER",null,null,null,null,null,null,"C:\\TestLocation\\abc\\financial files\\file_WAS_THERE.txt","Create"]
["FileMonitor_LA","filemon_job"," DAILY"," ",null,null,null,null,"120 Mins",null,null,"Upload_LA","NORMAL",null,null,"FINANCIAL_SERVER",null,null,null,null,null,null,"C:\\TestLocation\\abc\\financial files\\file_La.txt","Create"]
["FileMonitor_LA_DUPLICATE_0","filemon_job"," DAILY"," ",null,null,null,null,"120 Mins",null,null,"Post_Process_2A","NORMAL",null,null,"FINANCIAL_SERVER",null,null,null,null,null,null,"C:\\TestLocation\\abc\\financial files\\file_WAS_THERE.txt","Create"]
["FileMonitor_LA_DUPLICATE_1","filemon_job"," DAILY"," ",null,null,null,null,"120 Mins",null,null,"Post_Process_1A","NORMAL",null,null,"FINANCIAL_SERVER",null,null,null,null,null,null,"C:\\TestLocation\\abc\\financial files\\file_IS HERE.txt","Create"]
["FileMonitor_NY","filemon_job"," DAILY"," ",null,null,null,null,"120 Mins",null,null,"Upload_NY","NORMAL",null,null,"FINANCIAL_SERVER",null,null,null,null,null,null,"C:\\TestLocation\\abc\\financial files\\file_NY.txt","Create"]
["FTP_Financial_1","ftp_job"," DAILY"," ",null,null,null,null,null,null,null,"FileMonitor_Final_2","NORMAL",null,null,"FTP_SERVER","BANK_GUY",null,null,null,null,null,null,null,"BANK_SERVER","UPLOAD",9921,"D:\\BANK\\SERVER","C:\\TestLocation\\abc\\financial files\\file_WAS_THERE.txt"]
["FTP_Financial_2","ftp_job"," DAILY"," ",null,null,null,null,null,null,null,"FileMonitor_Final_1","NORMAL",null,null,"FTP_SERVER","CYBFTP",null,null,null,null,null,null,null,"BANK_SERVER","UPLOAD",9921,"D:\\BANK\\SERVER","C:\\TestLocation\\abc\\financial files\\file_IS_THERE.txt"]
["FTP_Financial_3","ftp_job"," DAILY"," ",null,null,null,null,null,null,null,"Archive_Files_1","NORMAL",null,null,"FTP_SERVER","CYBFTP",null,null,null,null,null,null,null,"BANK_SERVER","UPLOAD",9921,"D:\\BANK\\SERVER","C:\\TestLocation\\abc\\financial files\\file_IS_THERE.txt"]
["FTP_Financial_4","ftp_job"," DAILY"," ",null,null,null,null,null,null,null,"Archive_Files_1","NORMAL",null,null,"FTP_SERVER","CYBFTP",null,null,null,null,null,null,null,"BANK_SERVER","UPLOAD",9921,"D:\\BANK\\SERVER","C:\\TestLocation\\abc\\financial files\\file_IS_THERE.txt"]
["Generate_Chicago","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Generate_Chicago.bat","Chicago","Backup_Files","ABNORMAL",null,null,"FINANCIAL_SERVER"]
["Generate_Dallas","nt_job","Workdays\nSunday\n1st tuesday of January\n2nd thursday of February Less 1 DAY","Sunday\n1st Wednesday of July","`06.00",null,"`08.00","6 Mins","9 Mins","C:\\Financials\\scripts\\Generate_Dallas.bat","Dallas","Backup_Files","\"5\"","DPRES\nDPRES2\nDPRES3","1\n1\n1","FINANCIAL_SERVER",null,null,"SUBAPPL1"]
["Generate_LA","nt_job","Monday\nWednesday\nFriday","holidays",null,null,null,null,null,"C:\\Financials\\scripts\\GenerateLA.bat","LA","Backup_Files","UNCONDITIONAL",null,null,"FINANCIAL_SERVER"]
["Generate_NY","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\GenerateNY.bat","NY","Backup_Files","NORMAL",null,null,"FINANCIAL_SERVER"]
["Link_One","link","DAILY"," ",null,null,null,null,null,null,null,"FileMonitor_LA_DUPLICATE_0\nFileMonitor_LA_DUPLICATE_1","NORMAL\nNORMAL"]
["Post_Process_1A","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\SCRIPTS\\ScriptOne.bat","\"Parm1 is here\" \"Parm2 is here\"","Post_Process_1B","NORMAL",null,null,"FINANCIAL_SERVER"]
["Post_Process_1B","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\SCRIPTS\\ScriptOne.bat","\"Parm1 is here\" \"Parm2 is here\"","Send_Mail_1\nFTP_Financial_1","NORMAL\nNORMAL",null,null,"FINANCIAL_SERVER"]
["Post_Process_2A","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\SCRIPTS\\ScriptOne.bat","\"Parm1 is here\" \"Parm2 is here\"","Post_Process_2B","NORMAL",null,null,"FINANCIAL_SERVER"]
["Post_Process_2B","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\SCRIPTS\\ScriptOne.bat","\"Parm1 is here\" \"Parm2 is here\"","Send_Mail_2\nFTP_Financial_2","NORMAL\nNORMAL",null,null,"FINANCIAL_SERVER"]
["PreProcess_Chicago","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\PreProcess_Chicago.bat","Chicago","Generate_Chicago","NORMAL",null,null,"FINANCIAL_SERVER"]
["PreProcess_Dallas","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\PreProcess_Dallas.bat","Dallas","Generate_Dallas","NORMAL",null,null,"FINANCIAL_SERVER"]
["PreProcess_LA","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\PreProcess_LA.bat","LA","Generate_LA","NORMAL",null,null,"FINANCIAL_SERVER"]
["PreProcess_NY","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\PreProcess_NY.bat","NY","Generate_NY","NORMAL",null,null,"FINANCIAL_SERVER"]
["Process_Financial_one","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\SCRIPTS\\ScriptOne.bat","\"Parm1 is here\" \"Parm2 is here\"",null,null,null,null,"FINANCIAL_AGENT"]
["Process_Transactions","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Process1.bat","\"Parm1 is here\" \"Parm2 is here\"","Link_One","NORMAL",null,null,"FINANCIAL_SERVER"]
["Send_Mail_1","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Generate_Send.bat","All Records","Task_One","NORMAL",null,null,"FINANCIAL_SERVER"]
["Send_Mail_2","nt_job"," DAILY"," ",null,null,null,null,null,"C:\\Financials\\scripts\\Generate_Send.bat","All Records","Task_One","NORMAL",null,null,"FINANCIAL_SERVER"]
["START","nt_job"," DAILY"," ",null,null,null,null,"3 Mins","C:\\Financial\\scripts\\ClearFiles.bat","ALL","FileMonitor_LA\nFileMonitor_Dallas\nFileMonitor_NY\nDSTRIG_Chicago","NORMAL\nNORMAL\nNORMAL\nNORMAL",null,null,"FINANCIAL_SERVER"]
["Task_One","task"," DAILY"," ",null,null,null,null,null,null,null,"Archive_Files_1","NORMAL"]
["Upload_Chicago","ftp_job"," DAILY"," ",null,null,null,null,null,null,null,"PreProcess_Chicago","NORMAL",null,null,"FINANCIAL_SERVER","CYBFTP",null,null,null,null,null,null,null,"idbbankcentral","UPLOAD",9921,"C:\\TestLocation\\abc\\payroll files\\file_Chicago.txt","C:\\TestLocation\\abc\\payroll files\\file_Chicago.txt"]
["Upload_Dallas","ftp_job"," DAILY"," ",null,null,null,null,null,null,null,"PreProcess_Dallas","NORMAL",null,null,"FINANCIAL_SERVER","User_Financial",null,null,null,null,null,null,null,"Payroll_Server","DOWNLOAD",1202,"C:\\TestLocation\\abc\\payroll files\\file_Dallas.txt","C:\\TestLocation\\abc\\payroll files\\file_Dallas.txt"]
["Upload_LA","ftp_job"," DAILY"," ",null,null,null,null,null,null,null,"PreProcess_LA","NORMAL",null,null,"FINANCIAL_SERVER","CYBFTP",null,null,null,null,null,null,null,"idbbankcentral","UPLOAD",9921,"C:\\TestLocation\\abc\\payroll files\\file_LA.txt","C:\\TestLocation\\abc\\payroll files\\file_LA.txt"]
["Upload_NY","ftp_job"," DAILY"," ",null,null,null,null,null,null,null,"PreProcess_NY","NORMAL",null,null,"FINANCIAL_SERVER","CYBFTP",null,null,null,null,null,null,null,"idbbankcentral","UPLOAD",9921,"C:\\TestLocation\\abc\\payroll files\\file_NY.txt","C:\\TestLocation\\abc\\payroll files\\file_NY.txt"]