Name: TaskSchedulerAudit
Display Field: task_name
Type: Table
Description:
Copyright Text:
Max Record Count: 1000
Supported query Formats: JSON, geoJSON, PBF
Use Standardized Queries: True
HasZ: false
HasM: false
Has Attachments: false
Has Geometry Properties: false
HTML Popup Type: esriServerHTMLPopupTypeNone
Object ID Field: OBJECTID
Unique ID Field:
IsSystemMaintained : True
Global ID Field:
Type ID Field:
Fields:
- OBJECTID (type: esriFieldTypeOID, alias: OBJECTID, SQL Type: sqlTypeOther, length: 0, nullable: false, editable: false)
- server_name (type: esriFieldTypeString, alias: Server Name, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- audit_timestamp_utc (type: esriFieldTypeDate, alias: Audit Timestamp (UTC), SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- task_name (type: esriFieldTypeString, alias: Task Name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- task_path (type: esriFieldTypeString, alias: Task Path, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- task_full_name (type: esriFieldTypeString, alias: Task Full Name, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- state (type: esriFieldTypeString, alias: State, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- enabled (type: esriFieldTypeInteger, alias: Enabled, SQL Type: sqlTypeOther, nullable: true, editable: true)
- author (type: esriFieldTypeString, alias: Author, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- run_as_user (type: esriFieldTypeString, alias: Run As User, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- description (type: esriFieldTypeString, alias: Description, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- actions (type: esriFieldTypeString, alias: Actions, SQL Type: sqlTypeOther, length: 4000, nullable: true, editable: true)
- triggers (type: esriFieldTypeString, alias: Triggers, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- last_run_time (type: esriFieldTypeDate, alias: Last Run Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- next_run_time (type: esriFieldTypeDate, alias: Next Run Time, SQL Type: sqlTypeOther, length: 8, nullable: true, editable: true)
- last_task_result (type: esriFieldTypeDouble, alias: Last Task Result, SQL Type: sqlTypeOther, nullable: true, editable: true)
- last_result_text (type: esriFieldTypeString, alias: Last Result Text, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- number_of_missed_runs (type: esriFieldTypeInteger, alias: Missed Runs, SQL Type: sqlTypeOther, nullable: true, editable: true)
- health_status (type: esriFieldTypeString, alias: Health Status, SQL Type: sqlTypeOther, length: 50, nullable: true, editable: true)
- is_error (type: esriFieldTypeInteger, alias: Is Error, SQL Type: sqlTypeOther, nullable: true, editable: true)
- task_uri (type: esriFieldTypeString, alias: Task URI, SQL Type: sqlTypeOther, length: 1000, nullable: true, editable: true)
- hidden (type: esriFieldTypeInteger, alias: Hidden, SQL Type: sqlTypeOther, nullable: true, editable: true)
- principal_group_id (type: esriFieldTypeString, alias: Principal Group ID, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- principal_display (type: esriFieldTypeString, alias: Principal Display, SQL Type: sqlTypeOther, length: 255, nullable: true, editable: true)
- action_count (type: esriFieldTypeInteger, alias: Action Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- primary_executable (type: esriFieldTypeString, alias: Primary Executable, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- primary_arguments (type: esriFieldTypeString, alias: Primary Arguments, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- primary_working_directory (type: esriFieldTypeString, alias: Primary Working Directory, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- primary_executable_name (type: esriFieldTypeString, alias: Primary Executable Name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- command_target_path (type: esriFieldTypeString, alias: Command Target Path, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- command_target_name (type: esriFieldTypeString, alias: Command Target Name, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- command_target_type (type: esriFieldTypeString, alias: Command Target Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- trigger_count (type: esriFieldTypeInteger, alias: Trigger Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- trigger_types (type: esriFieldTypeString, alias: Trigger Types, SQL Type: sqlTypeOther, length: 500, nullable: true, editable: true)
- logon_type (type: esriFieldTypeString, alias: Logon Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- run_level (type: esriFieldTypeString, alias: Run Level, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- multiple_instances (type: esriFieldTypeString, alias: Multiple Instances, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- start_when_available (type: esriFieldTypeInteger, alias: Start When Available, SQL Type: sqlTypeOther, nullable: true, editable: true)
- run_only_if_network_available (type: esriFieldTypeInteger, alias: Run Only If Network Available, SQL Type: sqlTypeOther, nullable: true, editable: true)
- wake_to_run (type: esriFieldTypeInteger, alias: Wake To Run, SQL Type: sqlTypeOther, nullable: true, editable: true)
- execution_time_limit (type: esriFieldTypeString, alias: Execution Time Limit, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- restart_count (type: esriFieldTypeInteger, alias: Restart Count, SQL Type: sqlTypeOther, nullable: true, editable: true)
- restart_interval (type: esriFieldTypeString, alias: Restart Interval, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- last_run_age_hours (type: esriFieldTypeDouble, alias: Last Run Age Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- next_run_in_hours (type: esriFieldTypeDouble, alias: Next Run In Hours, SQL Type: sqlTypeOther, nullable: true, editable: true)
- is_running (type: esriFieldTypeInteger, alias: Is Running, SQL Type: sqlTypeOther, nullable: true, editable: true)
- is_warning (type: esriFieldTypeInteger, alias: Is Warning, SQL Type: sqlTypeOther, nullable: true, editable: true)
- is_overdue (type: esriFieldTypeInteger, alias: Is Overdue, SQL Type: sqlTypeOther, nullable: true, editable: true)
- has_missed_runs (type: esriFieldTypeInteger, alias: Has Missed Runs, SQL Type: sqlTypeOther, nullable: true, editable: true)
- needs_attention (type: esriFieldTypeInteger, alias: Needs Attention, SQL Type: sqlTypeOther, nullable: true, editable: true)
- attention_score (type: esriFieldTypeInteger, alias: Attention Score, SQL Type: sqlTypeOther, nullable: true, editable: true)
- attention_reason (type: esriFieldTypeString, alias: Attention Reason, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
- audit_batch_id (type: esriFieldTypeString, alias: Audit Batch ID, SQL Type: sqlTypeOther, length: 80, nullable: true, editable: true)
- batch_state (type: esriFieldTypeString, alias: Batch State, SQL Type: sqlTypeOther, length: 20, nullable: true, editable: true)
- schedule_bucket (type: esriFieldTypeString, alias: Schedule Bucket, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- is_highest_run_level (type: esriFieldTypeInteger, alias: Is Highest Run Level, SQL Type: sqlTypeOther, nullable: true, editable: true)
- is_parallel_instances (type: esriFieldTypeInteger, alias: Is Parallel Instances, SQL Type: sqlTypeOther, nullable: true, editable: true)
- is_executable (type: esriFieldTypeInteger, alias: Is Executable, SQL Type: sqlTypeOther, nullable: true, editable: true)
- has_restart_policy (type: esriFieldTypeInteger, alias: Has Restart Policy, SQL Type: sqlTypeOther, nullable: true, editable: true)
- has_next_run (type: esriFieldTypeInteger, alias: Has Next Run, SQL Type: sqlTypeOther, nullable: true, editable: true)
- has_multiple_actions (type: esriFieldTypeInteger, alias: Has Multiple Actions, SQL Type: sqlTypeOther, nullable: true, editable: true)
- primary_action_index (type: esriFieldTypeInteger, alias: Primary Action Index, SQL Type: sqlTypeOther, nullable: true, editable: true)
- primary_action_type (type: esriFieldTypeString, alias: Primary Action Type, SQL Type: sqlTypeOther, length: 100, nullable: true, editable: true)
- missing_next_run_expected (type: esriFieldTypeInteger, alias: Missing Next Run Expected, SQL Type: sqlTypeOther, nullable: true, editable: true)
- script_description (type: esriFieldTypeString, alias: Script Description, SQL Type: sqlTypeOther, length: 2000, nullable: true, editable: true)
Is Data Versioned: false
Has Contingent Values: false
Supports Rollback On Failure Parameter: true
Last Edit Date: 4/22/2026 9:02:05 PM
Schema Last Edit Date: 4/22/2026 1:44:14 PM
Data Last Edit Date: 4/22/2026 9:02:05 PM
Supported Operations:
Query
Query Pivot
Query Top Features
Query Analytic
Query Bins
Generate Renderer
Validate SQL
Get Estimates
ConvertFormat