### Body

There are some use cases where users want to trigger new DAG run as soon as one finished. This is a request I've seen several times with some variations (for example like this [Stackoverflow question](https://stackoverflow.com/q/75623153/14624409)) but the basic request is the same.

The workaround users do to get such functionality is place `TriggerDagRunOperator` as last task of their DAG invoking the same DAG:

```
from datetime import datetime

from airflow import DAG
from airflow.operators.empty import EmptyOperator
from airflow.operators.trigger_dagrun import TriggerDagRunOperator

with DAG(
    dag_id="example",
    start_date=datetime(2023, 1, 1,),
    catchup=False,
    schedule=None,
) as dag:
    task = EmptyOperator(task_id="first")
    trigger = TriggerDagRunOperator(
        task_id="trigger",
        trigger_dag_id="example",
    )

    task >> trigger

```

As you can see this works nicely:
![Screenshot 2023-03-03 at 14 20 51](https://user-images.githubusercontent.com/45845474/222718862-dfde8a41-24b6-4991-b318-b7f9784514f6.png)

My suggestion is to add first class support for this use case, so the above example will be changed to:

```

from datetime import datetime

from airflow import DAG
from airflow.operators.empty import EmptyOperator
from airflow.operators.trigger_dagrun import TriggerDagRunOperator

with DAG(
    dag_id="example",
    start_date=datetime(2023, 1, 1,),
    catchup=False,
    schedule="@continues",
) as dag:
    task = EmptyOperator(task_id="first")
```

I guess it won't exactly be `"@continues"` but more likely new [ScheduleArg](https://github.com/apache/airflow/blob/8b8552f5c4111fe0732067d7af06aa5285498a79/airflow/models/dag.py#L127) type but I show it like that just for simplification of the idea.

### Committer

- [X] I acknowledge that I am a maintainer/committer of the Apache Airflow project.
with create_session() as session:
            session.add(DagModel(dag_id="dag_default_view_old", default_view=None))
            session.commit()
            orm_dag = session.query(DagModel).filter(DagModel.dag_id == "dag_default_view_old").one()
        assert orm_dag.default_view is None
        assert orm_dag.get_default_view() == conf.get("webserver", "dag_default_view").lower()
    def test_dag_is_deactivated_upon_dagfile_deletion(self):
        dag_id = "old_existing_dag"
        dag_fileloc = "/usr/local/airflow/dags/non_existing_path.py"
        dag = DAG(
            dag_id,
            is_paused_upon_creation=True,
        )
        dag.fileloc = dag_fileloc
        session = settings.Session()
        with mock.patch("airflow.models.dag.DagCode.bulk_sync_to_db"):
            dag.sync_to_db(session=session)
        orm_dag = session.query(DagModel).filter(DagModel.dag_id == dag_id).one()
        assert orm_dag.is_active
        assert orm_dag.fileloc == dag_fileloc
        DagModel.deactivate_deleted_dags(list_py_file_paths(settings.DAGS_FOLDER))
        orm_dag = session.query(DagModel).filter(DagModel.dag_id == dag_id).one()
        assert not orm_dag.is_active
        session.execute(DagModel.__table__.delete().where(DagModel.dag_id == dag_id))
        session.close()
    def test_dag_naive_default_args_start_date_with_timezone(self):