SHOW ROUTINE LOAD

Examples

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;
```
Show the currently running routine \import job with the name test1
```
SHOW ROUTINE LOAD FOR test1;
```
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;
```
Show all running routine \import jobs in example_ db
```
use example_db;
SHOW ROUTINE LOAD;
```
Show the currently running routine \import job named test1 in example_ db
```
SHOW ROUTINE LOAD FOR example_db.test1;
```
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;
```