executing a process from SQL Server

[Rizwan]

i have to write a process for a client. this process will have no visual
component and will be scheduled to run as a job from Microsoft SQL Server
daily. I want to write this process in java instead of bunch of stored
procedures. can i do such a task? can somebody please explain the options
available to me in this regard?

Thanks

Rizwan

[Raymond DeCampo]

Rizwan wrote:

i have to write a process for a client. this process will have no visual
component and will be scheduled to run as a job from Microsoft SQL Server
daily. I want to write this process in java instead of bunch of stored
procedures. can i do such a task? can somebody please explain the options
available to me in this regard?

Personally, if I wanted to have a java process run every so often on the
Windows platform I would create a batch file to launch it and set it up
as a scheduled task. Why do you want to execute it from SQL Server?

Ray

--
XML is the programmer's duct tape.

[D R E]

test.. sorry...

"Rizwan" <hu******@pendylum.com> wrote in message
news:2Q*******************@news20.bellglobal.com.. .

i have to write a process for a client. this process will have no visual
component and will be scheduled to run as a job from Microsoft SQL Server
daily. I want to write this process in java instead of bunch of stored
procedures. can i do such a task? can somebody please explain the options
available to me in this regard?

Thanks

Rizwan

[Rizwan]

I actually dont want to execute it from SQL Server.We already have another
process which is a bunch of Stored Procs and we have defined a DTS which
calls those stored procedure and we have scheduled it to run it daily.
Thats why i said if we can do the same thing for this new process but
instead of stored procs use java. But i did not know that there are better
options available like one you mentioned. Can you explain your solution?

Thanks

"Raymond DeCampo" <rd******@spam.twcny.spam.rr.spam.com.spam> wrote in
message news:j4*******************@twister.nyroc.rr.com...

Rizwan wrote:

i have to write a process for a client. this process will have no visual
component and will be scheduled to run as a job from Microsoft SQL Server daily. I want to write this process in java instead of bunch of stored
procedures. can i do such a task? can somebody please explain the options available to me in this regard?

Personally, if I wanted to have a java process run every so often on the
Windows platform I would create a batch file to launch it and set it up
as a scheduled task. Why do you want to execute it from SQL Server?

Ray

--
XML is the programmer's duct tape.

[Raymond DeCampo]

Rizwan wrote:

I actually dont want to execute it from SQL Server.We already have another
process which is a bunch of Stored Procs and we have defined a DTS which
calls those stored procedure and we have scheduled it to run it daily.
Thats why i said if we can do the same thing for this new process but
instead of stored procs use java. But i did not know that there are better
options available like one you mentioned. Can you explain your solution?

Go into the Windows Help (Ctrl+F1) and search for "Scheduled Tasks" or
"at". Or search for these on Google.

Ray

--
XML is the programmer's duct tape.