This is an automated email from the ASF dual-hosted git repository.
kirs pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/doris-website.git
The following commit(s) were added to refs/heads/master by this push:
new 5e604f23df0e Delete JOB related documents in 2.0 (#476)
5e604f23df0e is described below
commit 5e604f23df0ef7da25407646a989de396642449c
Author: Calvin Kirs <[email protected]>
AuthorDate: Wed Mar 27 13:43:14 2024 +0800
Delete JOB related documents in 2.0 (#476)
---
.../Data-Definition-Statements/Alter/PAUSE-JOB.md | 53 ---------
.../Data-Definition-Statements/Alter/RESUME-JOB.md | 54 ---------
.../Data-Definition-Statements/Alter/STOP-JOB.md | 54 ---------
.../Create/CREATE-JOB.md | 129 ---------------------
versioned_sidebars/version-2.0-sidebars.json | 3 +-
5 files changed, 1 insertion(+), 292 deletions(-)
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/PAUSE-JOB.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/PAUSE-JOB.md
deleted file mode 100644
index 8f8dcbce6d4b..000000000000
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/PAUSE-JOB.md
+++ /dev/null
@@ -1,53 +0,0 @@
----
-{
-"title": "PAUSE-JOB",
-"language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## PAUSE-JOB
-
-### Name
-
-PAUSE JOB
-
-### Description
-
-User suspends a JOB job. A stopped job can be resumed with RESUME JOB.
-
-```sql
-PAUSE JOB FOR job_name;
-```
-
-### Example
-
-1. Pause the job named test1.
-
- ```sql
- PAUSE JOB FOR test1;
- ```
-
-###Keywords
-
- PAUSE, JOB
-
-### Best Practice
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/RESUME-JOB.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/RESUME-JOB.md
deleted file mode 100644
index 49eb11b23016..000000000000
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/RESUME-JOB.md
+++ /dev/null
@@ -1,54 +0,0 @@
----
-{
-"title": "RESUME-JOB",
-"language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## RESUME-JOB
-
-### Name
-
-RESUME JOB
-
-### Description
-
-Used to restart a JOB in PAUSE state. The restarted job will continue to be
executed periodically. A JOB in STOP state cannot be resumed.
-
-```sql
-RESUME JOB FOR job_name;
-```
-
-### Example
-
-1. Restart the JOB named test1.
-
- ```sql
- RESUME JOB FOR test1;
- ```
-
-### Keywords
-
- RESUME, JOB
-
-### Best Practice
-
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/STOP-JOB.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/STOP-JOB.md
deleted file mode 100644
index 05b9d0811141..000000000000
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Alter/STOP-JOB.md
+++ /dev/null
@@ -1,54 +0,0 @@
----
-{
-"title": "STOP-JOB",
-"language": "en"
-}
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-
-## STOP-JOB
-
-### Name
-
-STOP JOB
-
-### Description
-
-User stops a JOB job. A stopped job cannot be rerun.
-
-```sql
-STOP JOB FOR job_name;
-```
-
-### Example
-
-1. Stop the job named test1.
-
- ```sql
- STOP JOB FOR test1;
- ```
-
-### Keywords
-
- STOP, JOB
-
-### Best Practice
-
diff --git
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-JOB.md
b/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-JOB.md
deleted file mode 100644
index d89e0aad0d2a..000000000000
---
a/versioned_docs/version-2.0/sql-manual/sql-reference/Data-Definition-Statements/Create/CREATE-JOB.md
+++ /dev/null
@@ -1,129 +0,0 @@
----
-{
-"title": "CREATE-JOB",
-"language": "en"
-}
-
----
-
-<!--
-Licensed to the Apache Software Foundation (ASF) under one
-or more contributor license agreements. See the NOTICE file
-distributed with this work for additional information
-regarding copyright ownership. The ASF licenses this file
-to you under the Apache License, Version 2.0 (the
-"License"); you may not use this file except in compliance
-with the License. You may obtain a copy of the License at
-
- http://www.apache.org/licenses/LICENSE-2.0
-
-Unless required by applicable law or agreed to in writing,
-software distributed under the License is distributed on an
-"AS IS" BASIS, WITHOUT WARRANTIES OR CONDITIONS OF ANY
-KIND, either express or implied. See the License for the
-specific language governing permissions and limitations
-under the License.
--->
-## CREATE-JOB
-
-### Name
-
-CREATE JOB
-
-### Description
-
-Doris Job is a task that runs according to a predetermined plan and is used to
trigger predefined actions at a specific time or at a specified time interval,
thereby helping us to automate some tasks. Functionally, it is similar to the
operating system's
-Timing tasks (such as: cron in Linux, scheduled tasks in Windows). But Doris's
job scheduling can be accurate to the second level.
-
-There are two types of jobs: `ONE_TIME` and `BATCH`. Among them, the
`ONE_TIME` type Job will be triggered at the specified time point, which is
mainly used for one-time tasks, while the `BATCH` type Job will be triggered
cyclically within the specified time interval.
-Mainly used for tasks that are executed periodically.
-
-Currently only ***ADMIN*** permissions are supported for this operation.
-
-grammar:
-
-```sql
-CREATE
- job
- job_name
- ON SCHEDULE schedule
- [COMMENT 'string']
- DO sql_body;
-
-schedule: {
- AT timestamp
- | EVERY interval
- [STARTS timestamp]
- [ENDS timestamp ]
-}
-
-interval:
- quantity { DAY | HOUR | MINUTE |
- WEEK | SECOND }
-```
-
-A valid Job statement must contain the following
-
-- The keyword CREATE JOB plus the job name, which identifies unique events
within a db.
-- The ON SCHEDULE clause, which specifies the type of Job and when and how
often to trigger it.
-- The DO clause, which specifies the actions that need to be performed when
the Job job is triggered.
-
-Here is a minimal example:
-
-```sql
-CREATE JOB my_job ON SCHEDULE EVERY 1 MINUTE DO INSERT INTO db1.tbl1 SELECT *
FROM db2.tbl2;
-```
-
-This statement means to create a job named my_job to be executed every minute,
and the operation performed is to import the data in db2.tbl2 into db1.tbl1.
-
-The SCHEDULER statement is used to define the execution time, frequency and
duration of the job, which can specify a one-time job or a periodic job.
-- AT timestamp
-
- For one-time events, it specifies that the event is only executed once at a
given date and time timestamp, which must contain the date and time
-
-- EVERY
-
- Indicates that the operation is repeated periodically, which specifies the
execution frequency of the job. After the keyword, a time interval should be
specified, which can be days, hours, minutes, seconds, and weeks.
-
- - interval
-
- Used to specify the job execution frequency, it can be days, hours, minutes,
seconds, weeks. For example: `1 DAY` means execute once a day, `1 HOUR` means
execute once an hour, `1 MINUTE` means execute once every minute, `1 WEEK`
means execute once a week, `1 SECOND` means execute once every second .
-
- - STARTS timestamp
-
- It is used to specify the start time of the job. If not specified, it
will be executed from the next time point of the current time.
-
- - ENDS timestamp
-
- Used to specify the end time of the job, if not specified, it means
permanent execution.
-- DO
-
- It is used to specify the operation that needs to be performed when the job
is triggered. Currently, all ***INSERT, UPDATE*** operations are supported. We
will support more operations in the future.
-
-### Example
-
-Create a one-time job, which will be executed once at 2020-01-01 00:00:00, and
the operation performed is to import the data in db2.tbl2 into db1.tbl1.
-
-```sql
-
-CREATE JOB my_job ON SCHEDULE AT '2020-01-01 00:00:00' DO INSERT INTO db1.tbl1
SELECT * FROM db2.tbl2;
-
-```
-
-Create a periodic Job, which will start to execute at 2020-01-01 00:00:00,
once a day, and the operation is to import the data in db2.tbl2 into db1.tbl1.
-
-```sql
-CREATE JOB my_job ON SCHEDULE EVERY 1 DAY STARTS '2020-01-01 00:00:00' DO
INSERT INTO db1.tbl1 SELECT * FROM db2.tbl2 WHERE create_time >=
days_add(now(),-1);
-```
-
-Create a periodic Job, which will start to execute at 2020-01-01 00:00:00, and
execute once a day. The operation performed is to import the data in db2.tbl2
into db1.tbl1. This Job will be executed in 2020 Ends at -01-01 00:10:00.
-
-```sql
-CREATE JOB my_job ON SCHEDULER EVERY 1 DAY STARTS '2020-01-01 00:00:00' ENDS
'2020-01-01 00:10:00' DO INSERT INTO db1.tbl1 SELECT * FROM db2.tbl2
create_time >= days_add (now(),-1);
-```
-
-### Keywords
-
- CREATE, JOB
-
-### Best Practice
\ No newline at end of file
diff --git a/versioned_sidebars/version-2.0-sidebars.json
b/versioned_sidebars/version-2.0-sidebars.json
index e18d3bc4b135..0993557703b6 100644
--- a/versioned_sidebars/version-2.0-sidebars.json
+++ b/versioned_sidebars/version-2.0-sidebars.json
@@ -317,8 +317,7 @@
"label": "Query Admin",
"items": [
"admin-manual/query-admin/sql-interception",
- "admin-manual/query-admin/kill-query",
- "admin-manual/query-admin/job"
+ "admin-manual/query-admin/kill-query"
]
},
{
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
