HI,
we are using OOTB database for OD scheduler and i noticed that the schedule getting missed up from time to time. some experts on here suggested using some other database, so i decided to use mysql 5... in the process or configuring OD, from the OD-install doc page 131, it shows the syntax to create iwov_schedule table:
[size=2]CREATE TABLE IWOV_SCHEDULE (PK VARCHAR(128) NOT NULL, SCHEDULED_ITEM TIMESTAMP NOT NULL, TIME_EXPRESSION VARCHAR(128), .... RECURSET VARCHAR(128), REPAIR VARCHAR(128), REPEAT VARCHAR(128), ... YEARINV VARCHAR(128))
[left]
notice there is a column called REPEAT, and repeat is variable/keyword in mysql DB so mysql throws syntax error everytime i try to create that table with that column name. i dont want to change the name of the column and i dont have different db to use 
... and i know that OD supports mysql.
has anybody used mysql with OD? anyway around this issue?
and even if there is away to fool mysql to create a column named 'repeat', would OD be able to query that column using column name 'repeat'?
any ideas ?
[/left]
---UPDATE--------
i got to create the table with the column name 'repeat' using "backquote `` to escape the keyword... now od seems to connect and it shows that i have no scheduled deployments which is good. but when i try to schedule a deployment, as expected, it throws this error:
[/size]
[HTML]
For deployment: 22_test_1***ERROR - Failed scheduling job for test_1 at Sat Apr 14 12:55:00
DT 2007 +1d Sun Apr 15 12:55:00 MDT 2007. SchedulerException: SQL error 3: You have an
error in your SQL syntax; check the manual that corresponds to your MySQL server version for
the right syntax to use near 'REPEAT, STARTDEPLOY, STARTTIME, SYNCH, VERIFY,
WEEKDAY, WEEKINV, YEARINV) VALUES' at line 1
[/HTML]
[size=2]any work around? or do i need to go throu od queries and edit them with"``"?
[/size]
