SqlDbx
You are not logged in.
Pages: 1
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
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
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
Yes, soon we will have special comand line batch processing version of SqlDbx.
Offline
I realize this is an old thread, but what is the status of batch processing?
Offline
It will happen at some point next year.
Offline
Pages: 1