Transcript Appworx at SMCCD - San Mateo County Community College District
Using Appworx to Schedule Jobs in Banner Joyce Feimer - IT Services Analyst and Eric Raznick- Director, ITS San Mateo County Community College District
Appworx @ SMCCD •About 27,000 students
Appworx @ SMCCD • Live with Banner 7 - Student, HR, Fin Aid, Finance, • Other products: Xtender, SARS, Ad Astra, Hyperion (Brio), etc..
• Using Banner since version 1!
• Now using IBM AIX (Unix)
Appworx @ SMCCD • Why we wanted an automated Job Scheduler… – Had been on VMS for many years • Really liked “single threaded queues” • Didn’t have a lot of background in Unix shell scripts (cron is icky!) • Wanted something designed to work with Banner • Ability to monitor the jobs as they are running • You don’t have to feed it!
Appworx @ SMCCD
Type of jobs we run from Appworx:
•Nightly feeds (sfrfasc, sfpfaud, tgrfeed, tgrappl, furfeed, etc..) •Hourly Shell scripts (stats, moving files around) •External Application Extracts •Warehouse jobs •Daily Statistical Reports •“Clean-up” scripts •Creation of “static web pages” •Baseline Banner jobs!
D.log 2>&1 #end Colby # # Ted - PPRD no longer on LUCY since ban7 go LIVE!
# Clone PPRD on Sunday using the most resent backup ##00 07 * * 0 /usr/local/admin/backups/rman_dbdup0_pprd.shl >/usr/local/admin/lo gs/rman_dbdup0_pprd.log 2>&1 # # # Check for posting errors 5,25,45 8-19 * * 1-6 su - operfin -c "/usr/local/admin/chk_posting.shl PROD" >/v ar/tmp/chk_posting.log 2>&1 # # Restart Finance SleepWake to load output files into database for review 00 11,15 * * * su - operfin -c "/usr/local/admin/restart_slwk_db.shl PROD" >/var /tmp/restart_slwk_db.log 2>&1 # # Stop the Finance SleepWake processes 00 22 * * * su - operfin -c "/usr/local/admin/stop_slwk_db.shl PROD" >/var/tmp/
Creating a Module
Define the library
Define Program Type
Define Output
Define Prompts
Edit Prompts
Edit Prompts
Define Schedule
Chains
Expanded Chain
Predecessor - Success
Predecessor - Complete
Frequency of Runtimes
Frequency setup
Daily Reoccurring Jobs
Create Exceptions
Ad Hoc Submission
Enter Prompts & Options
Submit job to run
Successful Finish
Output Files
Output - Log files
Emailed Output
Unsuccessful Finish
Log File of Failed Job
Viewing Output Files • We licensed a small program called RptView (Report Viewer) for Windows from Drec Software • Looks like “greenbar”!
• Contact Info: – http://www.drecsoftware.com/
Output – List files
Important Things to Know… • If you copy the database – be careful… • In Chains - consideration of the “Predecessor” Actions are really important! ( Success, Failure, Complete , etc) • Does not use the path statement the same way – you need to make sure you are pointed at the right version of executables.
Questions???
Suggestions???
Many thanks from Eric & Joyce [email protected]