By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,798 Members | 1,336 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,798 IT Pros & Developers. It's quick & easy.

executing a process from SQL Server

P: n/a
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
Jul 17 '05 #1
Share this Question
Share on Google+
4 Replies


P: n/a
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.
Jul 17 '05 #2

P: n/a
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

Jul 17 '05 #3

P: n/a
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.

Jul 17 '05 #4

P: n/a
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.
Jul 17 '05 #5

This discussion thread is closed

Replies have been disabled for this discussion.