cancel
Showing results for 
Search instead for 
Did you mean: 
Data Engineering
Join discussions on data engineering best practices, architectures, and optimization strategies within the Databricks Community. Exchange insights and solutions with fellow data engineers.
cancel
Showing results for 
Search instead for 
Did you mean: 

Why is the workflow trigger status always paused?

guangyi
Contributor III

I create a workflow job via Asset Bundle. However, after deploying the job to the databricks the trigger status is always paused even no matter how I update the cron expression. I can manually trigger it successfully.

Screenshot 2024-07-16 at 12.05.51.png

Screenshot 2024-07-16 at 12.06.50.png

I cannot figure out why. Am I missing something? All the tasks in the workflow job is DLT pipeline, and the later one depends on the previous one

 

 

1 ACCEPTED SOLUTION

Accepted Solutions

jacovangelder
Honored Contributor

Next to the cron expression, you also need the following property: pause_status

For example:

schedule:
  quartz_cron_expression: 0 0 6 * * ?
  timezone_id: Europe/Amsterdam
  pause_status: UNPAUSED

The property can be set to PAUSED and UNPAUSED. 

Hope this helps!



View solution in original post

5 REPLIES 5

guangyi
Contributor III

I found a document is about Job ACL: https://docs.databricks.com/en/security/auth/access-control/index.html#job-acls

Is this because I don't have “Edit job settings” access? I knew I have been assigned to a access group, but I don't know what kind access I have right now.

Is there a way to check this besides ask the admin?

jacovangelder
Honored Contributor

Next to the cron expression, you also need the following property: pause_status

For example:

schedule:
  quartz_cron_expression: 0 0 6 * * ?
  timezone_id: Europe/Amsterdam
  pause_status: UNPAUSED

The property can be set to PAUSED and UNPAUSED. 

Hope this helps!



Hi jacovangelder, 

Thank you for your suggestion, I tried but it not working.

Hi jacovangelder,  

sorry my bad. It is not working because I used the lower cases. It working now

You're welcome! Glad it worked

Connect with Databricks Users in Your Area

Join a Regional User Group to connect with local Databricks users. Events will be happening in your city, and you won’t want to miss the chance to attend and share knowledge.

If there isn’t a group near you, start one and help create a community that brings people together.

Request a New Group