Unsupported Screen Size: The viewport size is too small for the theme to render properly.

Capabilities Of Job Manager

forums › forums › SQLyog › Sync tools, Migration, Scheduled Backup and Notifications › Capabilities Of Job Manager

  • This topic is empty.
Viewing 1 reply thread
  • Author
    Posts
    • November 4, 2010 at 12:19 pm #12146
      cliff.steer
      Member

      I would like to schedule a query which collects data from 5 or 6 tables and exports the data in a given format to Excel. I then need to schedule another query which import the results of the first query after it has been massaged in Excel and update another table. Is Job manager capable of doing this or must I complete the entire task in an SQL Query? Can Job Manager schedule SQL Queries?

    • November 4, 2010 at 2:36 pm #31498
      peterlaursen
      Participant

      To schedule a query use the 'Notifications Services' feature (from 'powertools' menu).  To generate output to be readable by Excel use a SELECT INTO OUTFILE query (but note that the file will be saved on the server machine) . Please refer: 

      http://www.webyog.com/faq/content/14/165/en/can-i-schedule-csv-export-and-import.html

  • Author
    Posts
Viewing 1 reply thread
  • You must be logged in to reply to this topic.