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]

[email protected]