Scheduling a java process

This question is more of a java question than a SQL Server question. But
still...
I am working in java; application server is Jboss and database is MS SQL
Server 2000.
I have a process written as an EJB in java. I want to schedule this proces
to run every hour every day. I was thinking about using the SQL Server to
schedule it. Is it possible? If yes then how? Any input is really
appreciated.
ThanksHi
Create a SQL Server agent job, with the job calling the EJB from the command
line. Not the best and cleanest solution, as database servers should not
have a lot of "application" instillations on it. IT should be a pure DB
server with all other processes running on a separate machine.
Regards
--
Mike Epprecht, Microsoft SQL Server MVP
Zurich, Switzerland
IM: mike@.epprecht.net
MVP Program: http://www.microsoft.com/mvp
Blog: http://www.msmvps.com/epprecht/
"Rizwan" <hussains@.pendylum.com> wrote in message
news:PMG4e.9963$Fy3.815744@.news20.bellglobal.com...
> This question is more of a java question than a SQL Server question. But
> still...
> I am working in java; application server is Jboss and database is MS SQL
> Server 2000.
> I have a process written as an EJB in java. I want to schedule this proces
> to run every hour every day. I was thinking about using the SQL Server to
> schedule it. Is it possible? If yes then how? Any input is really
> appreciated.
> Thanks
>
>|||How the job can call an EJB from the command line? Can you give an example ?
Thanks
Rizwan
"Mike Epprecht (SQL MVP)" <mike@.epprecht.net> wrote in message
news:uosA4rlOFHA.2144@.TK2MSFTNGP09.phx.gbl...
> Hi
> Create a SQL Server agent job, with the job calling the EJB from the
command
> line. Not the best and cleanest solution, as database servers should not
> have a lot of "application" instillations on it. IT should be a pure DB
> server with all other processes running on a separate machine.
> Regards
> --
> Mike Epprecht, Microsoft SQL Server MVP
> Zurich, Switzerland
> IM: mike@.epprecht.net
> MVP Program: http://www.microsoft.com/mvp
> Blog: http://www.msmvps.com/epprecht/
> "Rizwan" <hussains@.pendylum.com> wrote in message
> news:PMG4e.9963$Fy3.815744@.news20.bellglobal.com...
proces
to
>