What is the main difference between Schedule script execution and schedule job.

[vinuth v]

Hi All,

What is the main difference between Schedule script execution and schedule job.

Thanks,

Vinuth

[Kieran Anson]

Scheduled Job (sys_auto) is the base parent table to Scheduled Script Execution (sysauto_script)

There is also Scheduled Job (sys_trigger) which is the "brains" of the system. It's what coordinates the running of scripts/logic to each of the application node(s).

[Sid_Takali]

Hi @vinuth v 

"Scheduled Script Execution" and "Scheduled Job" are both used to automate tasks at specific times or intervals, but they serve slightly different purposes and are used in different contexts. 

Scheduled Script Execution

Purpose: Scheduled Script Execution is used to execute custom scripts at a specified time or on a recurring basis. 

Ideal for executing tasks that require custom logic, such as data manipulation, integrations, or complex workflows. 

Scheduled Job

Purpose: Scheduled Jobs are predefined or out-of-the-box jobs that execute certain tasks at a scheduled time.

Used for routine maintenance tasks, data processing, or background jobs that are part of the system’s core functionality. 

Key Differences

Aspect Scheduled Script Execution Scheduled Job

Flexibility	High; custom JavaScript scripts can be run.	Lower; typically predefined tasks.
Complexity	More complex, requires scripting knowledge.	Easier to configure, often with simple parameters.
Use Cases	Custom operations, data processing, etc.	Routine tasks, system maintenance, etc.
Customization	Fully customizable through scripts.	Limited to predefined logic and parameters.
Access Location	System Definition > Scheduled Script Executions	System Scheduler > Scheduled Jobs