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