topic Re: Why is the workflow trigger status always paused? in Data Engineering

Why is the workflow trigger status always paused?

guangyi — Tue, 16 Jul 2024 04:12:38 GMT

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.

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

Re: Why is the workflow trigger status always paused?

guangyi — Tue, 16 Jul 2024 06:08:07 GMT

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?

Re: Why is the workflow trigger status always paused?

jacovangelder — Tue, 16 Jul 2024 07:05:05 GMT

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!

Re: Why is the workflow trigger status always paused?

guangyi — Tue, 16 Jul 2024 07:56:00 GMT

Hi jacovangelder,

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

Re: Why is the workflow trigger status always paused?

guangyi — Tue, 16 Jul 2024 08:15:19 GMT

Hi jacovangelder,

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

Re: Why is the workflow trigger status always paused?

jacovangelder — Tue, 16 Jul 2024 10:42:20 GMT

You're welcome! Glad it worked