I undestand that you mean I use external scheduler. But I try to execute
sql with MaxDB scheduler.
I tried the following variants
scheduler_create_job 00:00:00 sql_connect SCHEDULEDJOBS,123
scheduler_create_job 1 "sql_execute call SCHEDULEDJOBS.CLEAR_LABORATORY"
This is doesn't work because each job starts in different processes.
The variant
scheduler_create_job 00:00:00 "sql_connect SCHEDULEDJOBS,123"
"sql_execute call SCHEDULEDJOBS.CLEAR_LABORATORY"
executes only the first command.
Can you help me?
Thanks in advance,
Alexey Gaidukov.
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]
