I'm looking to see if its possible to stop an automation if it goes past 4am?
I have another job which runs at 4:30 and I don't want these jobs to clash.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.
Sign up to join this communityI'm looking to see if its possible to stop an automation if it goes past 4am?
I have another job which runs at 4:30 and I don't want these jobs to clash.
This would likely need to be a third automation utilizing Script activities.
What you would do is set this automation to run daily at 4AM with only the script activity.
I would have this script activity utilize the internal SSJS API capabilities to interact with Automation Studio to do the following actions:
I would then add a script activity to the end of your 2nd automation and have this script activity restart the first automation so it can run as normal.
This is a good recently asked question to reference.
Perhaps you can do this, assuming both automations run on the same days:
Run automation 1 on schedule basis, at the last step of the automation do a file export into a FTP location. The export can be of a dummy DE and as simple as just one row with one field.
Trigger the 2nd Automation off the file drop, this way the 2nd automation only runs if the first has finished.