Hi, I want to create a unix script which will keep on executing 'sp_who' for sybase database (name = my_sybase) in every 5 mins. Please help

Years ago, I was a sybase admin, but no more. I do have this stub program left over which you can probably modify to call 'sp_who'. #!/bin/ksh SERVERNAME="TEST_SERVER" USER="my_user" PASSWD="my_pass" DBNAME="my_sybase" DBCOMMAND="eval isql -S $SERVERNAME -U $USER -P $PASSWD" $DBCOMMAND << MSG use $DBNAME go SELECT * FROM test_table go MSG # end script If you want to call it every 5 minutes, you need to set up cron. This calls my_script every 5 minutes: # untested */5 * * * * my_script

cron if you want script to run 24/7. to run a script you can eyeball: #!/bin/ksh SERVERNAME="TEST_SERVER" USER="my_user" PASSWD="my_pass" DBNAME="my_sybase" while [ true ] do DBCOMMAND="eval isql -S $SERVERNAME -U $USER -P $PASSWD" $DBCOMMAND << MSG use $DBNAME go SELECT * FROM test_table go MSG # end script sleep 300 done