Why is the workflow trigger status always paused?

guangyi
Contributor III

‎07-15-2024 09:12 PM

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

 

 

0 Kudos

guangyi
Contributor III

‎07-15-2024 11:08 PM

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
Databricks MVP

‎07-16-2024 12:05 AM

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

guangyi
Contributor III
In response to jacovangelder

‎07-16-2024 12:56 AM

Hi jacovangelder, 

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

guangyi
Contributor III
In response to jacovangelder

‎07-16-2024 01:15 AM

Hi jacovangelder,  

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

jacovangelder
Databricks MVP
In response to guangyi

‎07-16-2024 03:42 AM

You're welcome! Glad it worked