Navigation
- FAQ Home
- All categories
- About Webyog support and about this FAQ
- About the SQLyog program

- Connection issues

- Using the GUI
- Managing your MySQL Database Systems

- Database Schema Synchronization
- MySQL DATA synchronization
- SQL Scheduler and Reporting Tool
- Importing external data
- Backup/Restore
- SQLyog Job Agent (SJA)
- Working with Views, Stored Procedures and Triggers
- Character Set and Localization Issues
- MySQL bugs that affect SQLyog
- Questions on Open Source and Compiling
- Sitemap
10 users online | 10 Guests and 0 Registered
Most popular FAQs 
- I get error 1130 "Host is not allowed to ... (169314 views)
- Error no. 2003: Can't connect... (86270 views)
- SQLyog Version History (63952 views)
- Error no. 1045: "Connection denied..." (61346 views)
- Error no. 1251: "Client does not support authentication..." (58317 views)
- Error No. 2005: Unknown MySQL server host... (50192 views)
- What is HTTP-tunneling? (42282 views)
- What Is SSH and SSH-tunneling? (38071 views)
- Can I use SQLyog with the WINE Windows emulator ... (34944 views)
- Why are Stored Procedures not created when I import ... (34267 views)
Latest FAQs 
- SQLyog Version History (2012-01-26 08:20)
- SQLyog is a client for the MySQL server - ... (2011-11-04 04:48)
- I get error 1130 "Host is not allowed to ... (2011-11-01 05:21)
- Problems on Ubuntu 11.x (2011-10-29 13:02)
- Problems creating a functional DSN on 64 bit Windows. ... (2011-09-15 14:34)
Sticky FAQs
SQLyog Job Agent (SJA) » General questions about SJA
ID #1023
Can I execute more SJA jobs at the same time?
Well, Yes you can. Absolutely no problem in doing so.
But the result of it may be unpredictable in cases where one or more of the jobs alter data. In that case it probably would be better to build a .bat file, and execute this instead. Such a .bat file could look like:
SJA my_importjob.xml
SJA my_notifyjob.xml
SJA my_syncjob.xml
SJA my_backupjob.xmlThis example will start the job as described in the file my_notifyjob.xml when the job described in my_importjob.xml has finished executing and so on. If you don't want Windows to wait starting each job until the preceding one has finished you can use the call command like
call SJA my_importjob.xml
call SJA my_notifyjob.xml
call SJA my_syncjob.xml
call SJA my_backupjob.xmlAnd this 'hybrid' example'
SJA my_importjob.xml
SJA my_notifyjob.xml
call SJA my_syncjob.xml
call SJA my_backupjob.xmlwaits for the notify-job to finish. After that the sync-job and the backup-job are executed in parallel.
Tags: -
Related entries:
- Welcome to the SQLyog FAQ
- Installation and upgrading
- SQLyog Version History
- Can I perform "incremental import" with the SQLyog Import External Data Tool?
- Error no. 1045: "Connection denied..."
Last update: 2005-09-21 05:18
Author: Peter Laursen
Revision: 1.0
{translationForm}
You can comment this FAQ