This method doens't work. I tried it before and right now I've made the
test
dbmcli on dcdb>[EMAIL PROTECTED] DCDB]# dbmcli -d dcdb -u sched,dc -uSQL
SCHEDULEDJOBS,123
---
dbmcli on dcdb>scheduler_create_job 09:38:00 "sql_execute call
SCHEDULEDJOBS.CLEAR_LABORATORY"
OK
0
---
dbmcli on dcdb>scheduler_list_jobs
OK
ID 0
owner: SCHED
status: active
runs: at 09:38:00
last run: 2006-01-11 09:38:01
DBM Server PID 29920
return code ERR (-24988)
dbm_command: sql_execute call SCHEDULEDJOBS.CLEAR_LABORATORY
---
dbmcli on dcdb>sql_execute call SCHEDULEDJOBS.CLEAR_LABORATORY
OK
---
Werner, Marc-Philip пишет:
Hi Alexey,
you could schedule a
dbmcli -u <dbmuser>,<dbmpass> -d <dbname> -uSQL [<sqluser>,<sqlpass>] -c sql_execute select count(*) from dual;
As you can see, sqluser and sqlpass are optional. If you leave that out, the
system administrator's account is used.
For arbitrary command sequences you must schedule the execution of an input script, e.g.
dbmcli -u <dbmuser>,<dbmpass> -d <dbname> -i <inputfile>.
Please look up the documentation at http://dev.mysql.com/doc/maxdb/en/default.htm for the details.
Regards,
Marc-Philip
________________________________
From: Alexey Gaidukov [mailto:[EMAIL PROTECTED]
Sent: Dienstag, 10. Januar 2006 01:37
To: Werner, Marc-Philip
Cc: maxdb@lists.mysql.com
Subject: Re: sql_execute with user_spec
I want to execute sql statement from sql user in scheduler. How can I
do this?
Thanks in advance,
Alexey Gaidukov.
Werner, Marc-Philip пишет:
Hi Alexey,
Maxdb 7.6.00.16 Linux. From dbmcli documentation
sql_execute <user_identification> <statement>
*<user_identification> :: = <user_spec> | <user_type>*
*<user_spec> :: =
<database_user>,<database_user_password>*
*<user_type> :: = user-type=<value>
*
The documentation is wrong and will be fixed. The option
<user_spec>
does not exist. The option <user_type> does work though.
Sorry for the inconvenience.
Regards,
Marc-Philip
--
MaxDB Discussion Mailing List
For list archives: http://lists.mysql.com/maxdb
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
