a Script to shutdown a service when a Sybase table reads over a certain count

d-cam · 08-03-2009, 02:50 AM

Someone at work has requested if i can find out anything on the above.
Been googling around as well as i have only been using Linux for 2 months now.

basically there is a SYBASE ASE installation on the server, which a tomcat based website references.They want the service to stop once a certain row limit is reached in the table.

I know i have to do a count statement on the sybase table from ISQL.
But how can i create the action "service website stop" once the count value reaches 4000 ?

any help would be really appreciated

thanks in advance

chrism01 · 08-03-2009, 10:46 PM

Well, on RHEL its

service httpd stop

although you'd prob need the program to have root privs, possibly via sudo.
I'd probably do this in Perl, but if you're comfortable with Java (you mentioned tomcat) that would work too.
What have you got so far?

d-cam · 08-11-2009, 06:07 AM

Quote:

Originally Posted by chrism01

Well, on RHEL its

service httpd stop

although you'd prob need the program to have root privs, possibly via sudo.
I'd probably do this in Perl, but if you're comfortable with Java (you mentioned tomcat) that would work too.
What have you got so far?

Thanks i will try searching on Perl

i am a total noob on this OS and that comes from working predominantly with Windows GUI for the last 5 years.

But i am sllllloooooowwwwwwly getting the hang of RH linux and finding it very intersting

thanks for the pointer