El contenido no se encuentra disponible en el idioma seleccionado. Estamos trabajando continuamente para agregar más idiomas. Gracias por su apoyo.

Compute
Elastic Cloud Server
Huawei Cloud Flexus
Bare Metal Server
Auto Scaling
Image Management Service
Dedicated Host
FunctionGraph
Cloud Phone Host
Huawei Cloud EulerOS
Networking
Virtual Private Cloud
Elastic IP
Elastic Load Balance
NAT Gateway
Direct Connect
Virtual Private Network
VPC Endpoint
Cloud Connect
Enterprise Router
Enterprise Switch
Global Accelerator
Management & Governance
Cloud Eye
Identity and Access Management
Cloud Trace Service
Resource Formation Service
Tag Management Service
Log Tank Service
Config
OneAccess
Resource Access Manager
Simple Message Notification
Application Performance Management
Application Operations Management
Organizations
Optimization Advisor
IAM Identity Center
Cloud Operations Center
Resource Governance Center
Migration
Server Migration Service
Object Storage Migration Service
Cloud Data Migration
Migration Center
Cloud Ecosystem
KooGallery
Partner Center
User Support
My Account
Billing Center
Cost Center
Resource Center
Enterprise Management
Service Tickets
HUAWEI CLOUD (International) FAQs
ICP Filing
Support Plans
My Credentials
Customer Operation Capabilities
Partner Support Plans
Professional Services
Analytics
MapReduce Service
Data Lake Insight
CloudTable Service
Cloud Search Service
Data Lake Visualization
Data Ingestion Service
GaussDB(DWS)
DataArts Studio
Data Lake Factory
DataArts Lake Formation
IoT
IoT Device Access
Others
Product Pricing Details
System Permissions
Console Quick Start
Common FAQs
Instructions for Associating with a HUAWEI CLOUD Partner
Message Center
Security & Compliance
Security Technologies and Applications
Web Application Firewall
Host Security Service
Cloud Firewall
SecMaster
Anti-DDoS Service
Data Encryption Workshop
Database Security Service
Cloud Bastion Host
Data Security Center
Cloud Certificate Manager
Edge Security
Situation Awareness
Managed Threat Detection
Blockchain
Blockchain Service
Web3 Node Engine Service
Media Services
Media Processing Center
Video On Demand
Live
SparkRTC
MetaStudio
Storage
Object Storage Service
Elastic Volume Service
Cloud Backup and Recovery
Storage Disaster Recovery Service
Scalable File Service Turbo
Scalable File Service
Volume Backup Service
Cloud Server Backup Service
Data Express Service
Dedicated Distributed Storage Service
Containers
Cloud Container Engine
Software Repository for Container
Application Service Mesh
Ubiquitous Cloud Native Service
Cloud Container Instance
Databases
Relational Database Service
Document Database Service
Data Admin Service
Data Replication Service
GeminiDB
GaussDB
Distributed Database Middleware
Database and Application Migration UGO
TaurusDB
Middleware
Distributed Cache Service
API Gateway
Distributed Message Service for Kafka
Distributed Message Service for RabbitMQ
Distributed Message Service for RocketMQ
Cloud Service Engine
Multi-Site High Availability Service
EventGrid
Dedicated Cloud
Dedicated Computing Cluster
Business Applications
Workspace
ROMA Connect
Message & SMS
Domain Name Service
Edge Data Center Management
Meeting
AI
Face Recognition Service
Graph Engine Service
Content Moderation
Image Recognition
Optical Character Recognition
ModelArts
ImageSearch
Conversational Bot Service
Speech Interaction Service
Huawei HiLens
Video Intelligent Analysis Service
Developer Tools
SDK Developer Guide
API Request Signing Guide
Terraform
Koo Command Line Interface
Content Delivery & Edge Computing
Content Delivery Network
Intelligent EdgeFabric
CloudPond
Intelligent EdgeCloud
Solutions
SAP Cloud
High Performance Computing
Developer Services
ServiceStage
CodeArts
CodeArts PerfTest
CodeArts Req
CodeArts Pipeline
CodeArts Build
CodeArts Deploy
CodeArts Artifact
CodeArts TestPlan
CodeArts Check
CodeArts Repo
Cloud Application Engine
MacroVerse aPaaS
KooMessage
KooPhone
KooDrive
On this page

Show all

MY_SCHEDULER_JOBS

Updated on 2024-06-03 GMT+08:00

MY_SCHEDULER_JOBS displays information about all DBE_SCHEDULER scheduled tasks owned by the current user in the database. By default, this view exists in the PG_CATALOG and SYS schemas and all users can access this view.

Table 1 MY_SCHEDULER_JOBS columns

Name

Type

Description

job_name

text

Name of a scheduler job.

job_subname

character varying(128)

Not supported. Set it to NULL.

job_style

text

Action mode of a scheduler job.

job_creator

name

Creator of a scheduler job.

client_id

character varying(65)

Not supported. Set it to NULL.

global_uid

character varying(33)

Not supported. Set it to NULL.

program_owner

character varying(4000)

Owner of a program referenced by a scheduler job.

program_name

text

Name of the program referenced by a scheduler job.

job_type

character varying(16)

Type of the inline program of a scheduler job.

job_action

text

Program content of a scheduler job.

number_of_arguments

text

Number of parameters of a scheduler job.

schedule_owner

character varying(4000)

Not supported. Set it to NULL.

schedule_name

text

Name of the schedule referenced by a scheduler job.

schedule_type

character varying(12)

Not supported. Set it to NULL.

start_date

timestamp without time zone

Start time of a scheduler job.

repeat_interval

text

Period of a scheduler job.

event_queue_owner

character varying(128)

Not supported. Set it to NULL.

event_queue_name

character varying(128)

Not supported. Set it to NULL.

event_queue_agent

character varying(523)

Not supported. Set it to NULL.

event_condition

character varying(4000)

Not supported. Set it to NULL.

event_rule

character varying(261)

Not supported. Set it to NULL.

file_watcher_owner

character varying(261)

Not supported. Set it to NULL.

file_watcher_name

character varying(261)

Not supported. Set it to NULL.

end_date

timestamp without time zone

End time of a scheduler job.

job_class

text

Name of the scheduler job class to which a scheduler job belongs.

enabled

boolean

Status of a scheduler job.

auto_drop

text

Status of the automatic deletion function of a scheduler job.

restart_on_recovery

character varying(5)

Not supported. Set it to NULL.

restart_on_failure

character varying(5)

Not supported. Set it to NULL.

state

"char"

Status of a scheduler job.

job_priority

numeric

Not supported. Set it to NULL.

run_count

numeric

Not supported. Set it to NULL.

uptime_run_count

numeric

Not supported. Set it to NULL.

max_runs

numeric

Not supported. Set it to NULL.

failure_count

smallint

Number of scheduler job failures.

uptime_failure_count

numeric

Not supported. Set it to NULL.

max_failures

numeric

Maximum number of failures allowed before the status of a scheduler job is marked as broken.

retry_count

numeric

Not supported. Set it to NULL.

last_start_date

timestamp without time zone

Last time when a scheduler job was started.

last_run_duration

interval day to second(6)

Last execution duration of a scheduler job.

next_run_date

timestamp without time zone

Next execution time of a scheduler job.

schedule_limit

interval day to second(0)

Not supported. Set it to NULL.

max_run_duration

interval day to second(0)

Not supported. Set it to NULL.

logging_level

character varying(11)

Not supported. Set it to NULL.

store_output

character varying(5)

Specifies whether to store the output information of all scheduler jobs.

stop_on_window_close

character varying(5)

Not supported. Set it to NULL.

instance_stickiness

character varying(5)

Not supported. Set it to NULL.

raise_events

character varying(4000)

Not supported. Set it to NULL.

system

character varying(5)

Not supported. Set it to NULL.

job_weight

numeric

Not supported. Set it to NULL.

nls_env

character varying(4000)

Not supported. Set it to NULL.

source

character varying(128)

Not supported. Set it to NULL.

number_of_destinations

numeric

Not supported. Set it to NULL.

destination_owner

character varying(261)

Not supported. Set it to NULL.

destination

text

Target name of a scheduler job.

If the value of destination is CCN, the task is a CCN job. For details, see DBE_SCHEDULER.

credential_owner

character varying(128)

Not supported. Set it to NULL.

credential_name

text

Certificate name of a scheduler job.

instance_id

oid

OID of the current database.

deferred_drop

character varying(5)

Not supported. Set it to NULL.

allow_runs_in_restricted_mode

character varying(5)

Not supported. Set it to NULL.

comments

text

Comments of a scheduler job.

flags

numeric

Not supported. Set it to NULL.

restartable

character varying(5)

Not supported. Set it to NULL.

has_constraints

character varying(5)

Not supported. Set it to NULL.

connect_credential_owner

character varying(128)

Not supported. Set it to NULL.

connect_credential_name

character varying(128)

Not supported. Set it to NULL.

fail_on_script_error

character varying(5)

Not supported. Set it to NULL.

Utilizamos cookies para mejorar nuestro sitio y tu experiencia. Al continuar navegando en nuestro sitio, tú aceptas nuestra política de cookies. Descubre más

Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback