BookmarkSubscribeRSS Feed
ASASProgrammer
Calcite | Level 5

Hi,

The flow contains two jobs, which are triggered by their File event separately.

File1 Exists --> Job1

File2 Exists --> Job2

The problem is that when the flow is triggered and only File1 is there, the job2 won't run and it causes the flow never complete with the status of Running.

Any solution without programming for this?

Thanks,

Shi

2 REPLIES 2
Patrick
Opal | Level 21

Not sure but I believe if you set the file trigger event for file 2 to "exist" then it should work.

jakarman
Barite | Level 11

Tis type of logic is coming from advanced schedulers (Ctrl-D OPC expect LSF the same).
The flow(job) is collection of programs to run on a regular scheme.

- Dependicies and events are influencing when each program is allowed to run

- actions as suspending a program (removing from requirements) are possible


The logic to solve will be:

1- after a planned time and file2 does not exist have job2 suspendend (possible by running a job)

2- When Job2 is allowed to run more than once and is capable running on an empty file
    Have a time event within the flow planned to deliver an empty file

3- This will be an excpetional case. Have your operators being instructed to suspend the job2 as reaction on the alert message (late) of the scheduling environment.

All depends how the environment is organized and the options in your tooling.   

---->-- ja karman --<-----

sas-innovate-2024.png

Don't miss out on SAS Innovate - Register now for the FREE Livestream!

Can't make it to Vegas? No problem! Watch our general sessions LIVE or on-demand starting April 17th. Hear from SAS execs, best-selling author Adam Grant, Hot Ones host Sean Evans, top tech journalist Kara Swisher, AI expert Cassie Kozyrkov, and the mind-blowing dance crew iLuminate! Plus, get access to over 20 breakout sessions.

 

Register now!

How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 2 replies
  • 943 views
  • 0 likes
  • 3 in conversation