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]

Re: executing a process from SQL Server

Rizwan wrote:[color=blue]
> 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?
>[/color]

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]

Re: executing a process from SQL Server

test.. sorry...

"Rizwan" <hussains@pendy lum.com> wrote in message
news:2QAIc.5852 $RD4.553363@new s20.bellglobal. com...[color=blue]
> 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
>
>[/color]

[Rizwan]

Re: executing a process from SQL Server

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" <rdecampo@spam. twcny.spam.rr.s pam.com.spam> wrote in
message news:j4FIc.6202 5$bp1.55875@twi ster.nyroc.rr.c om...[color=blue]
> Rizwan wrote:[color=green]
> > 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[/color][/color]
Server[color=blue][color=green]
> > 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[/color][/color]
options[color=blue][color=green]
> > available to me in this regard?
> >[/color]
>
> 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.[/color]

[Raymond DeCampo]

Re: [OT]executing a process from SQL Server

Rizwan wrote:[color=blue]
> 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?
>[/color]

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.