SqlDbx Forum

SqlDbx

You are not logged in.

#1 2013-04-19 12:28:00

dimarules
Member

Command Line example for SQLDbx

Hi,

I have a stored proc on a Sybase server that I want to execute every night via a scheduled job.  Is there a way to call SQLDbx with parameters to do this for me?

Thanks

Offline

#2 2013-04-22 08:35:32

sqldbxhelp
Administrator

Re: Command Line example for SQLDbx

Create script with:
exec stored_procedure_name
Save it as C:TempScript1.sql
Start SqlDbx with command line:
-t sybase -sserver_name -ddb_name -uuser_name -ppassword -q"C:TempScript1.sql"
Let me make it clear. SqlDbx is not a batch processing application.
Above command line will start SqlDbx, execute your stored procedure and it will stay open.

Offline

#3 2013-04-22 14:34:36

dimarules
Member

Re: Command Line example for SQLDbx

Thank you. Any way to add this functionality in the future where it will run as a batch processing app?  It could be VERY useful.  Perhaps even have a way to execute a script without an actual sql file.

Offline

#4 2013-04-22 16:10:18

sqldbxhelp
Administrator

Re: Command Line example for SQLDbx

Yes, soon we will have special comand line batch processing version of SqlDbx.

Offline

#5 2015-10-27 14:13:08

mrschwarz
Member

Re: Command Line example for SQLDbx

I realize this is an old thread, but what is the status of batch processing?

Offline

#6 2015-10-27 19:55:17

sqldbxhelp
Administrator

Re: Command Line example for SQLDbx

It will happen at some point next year.

Offline

Board footer

Powered by FluxBB