forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Error Opening Session Job File
- This topic is empty.
-
AuthorPosts
-
-
April 12, 2007 at 1:05 pm #10285fredpMember
Hi,
I am using sja 5.25 on a linux box.
For some reason when I want to run sja using a cron job, nothing happens and I receive the error:
Error opening session job file
I have read previous posts about this before and tried suggested fix, still no luck.
Everything works fine when I use it like: ./sja jobfile.xml from the command line
I have all my rights set correctly, I have tried with and without specifying session and log files, with full path etc …
Anybody any ideas ?
-
April 12, 2007 at 2:07 pm #23776peterlaursenParticipant
I understand you can run it interactively from a console, but not from CRON. true?
If so it is a file system or privilege issue!
First understand that the “session xml file” is not the jobfile. They are two different files (both in XML format). The session XML file is used internally.
Did you try the full syntax like:
Code:./sja “full path to jobfile.xml” s”full path to sessionfile.xml” l”full path to logfile.txt”note the use of doublequotes and the s-parameter to specify the session file path. Specify a path where the user executing the corbjob has read and write privileges.
-
April 12, 2007 at 2:41 pm #23777fredpMemberpeterlaursen wrote on Apr 12 2007, 04:07 PM:I understand you can run it interactively from a console, but not from CRON. true?
If so it is a file system or privilege issue!
First understand that the “session xml file” is not the jobfile. They are two different files (both in XML format). The session XML file is used internally.
Did you try the full syntax like:
Code:./sja “full path to jobfile.xml” s”full path to sessionfile.xml” l”full path to logfile.txt”note the use of doublequotes and the s-parameter to specify the session file path. Specify a path where the user executing the corbjob has read and write privileges.
Hi,
I knew the difference between the jobfile session and log.
On a previous attempt I simply forgot to put the double quotes around the jobfile as well.
It is now working, providing full path to the jobfile / sessionfile / logfile all surrounded by quotes.
Many thanks.
-
-
AuthorPosts
- You must be logged in to reply to this topic.