#!/bin/sh # # This script finds out if any SAP jobs are running. # It is useful to start and stop an SAP backup/batch server # a=`sqlplus -s system/manager << !! set pagesize 0 set heading off select jobname from sapr3.tbtco where status = 'R'; exit !!` b=`echo $a|grep -v selected|wc -l` if [ $b = 0 ] then echo "No jobs are running" else echo "Jobs are running" fi