SHOW ROUTINE LOAD

Examples

1. Show all routine import jobs (including stopped or cancelled jobs) with the name test1. The result is one or more rows.

   SHOW ALL ROUTINE LOAD FOR test1;

2. Show the currently running routine import job with the name test1

   SHOW ROUTINE LOAD FOR test1;

3. Show all routine import jobs (including stopped or cancelled jobs) in example_ db. The result is one or more rows.

   use example_db;
   SHOW ALL ROUTINE LOAD;

4. Show all running routine import jobs in example_ db

   use example_db;
   SHOW ROUTINE LOAD;

5. Show the currently running routine import job named test1 in example_ db

   SHOW ROUTINE LOAD FOR example_db.test1;

6. Show all routine import jobs (including stopped or cancelled jobs) with the name test1. The result is one or more rows in example_ db

   SHOW ALL ROUTINE LOAD FOR example_db.test1;