File creation date = Current Date then start DS Sequence

[Dodge]

Hi all,

I have to implement a logic in a Sequence Job

Everyday in the morining files will be created on the Server.
My DS job will extract data from files and loads into Oracle table.

I need to put a condition.. that if the file created date = Current date then DS Sequence needs to start else fail and send a warning message ....

Thanks in advance....

[max.madsen]

I'm busy now, but ..
This logic can be extensive, full of details but it is simple.
The first step is to list the files and their dates:

Code: Select all

 - ls $arq -lt --time-style=long-iso | cut -d" " -f6,7 

With this command you can pick the date.
The rest believe you can.

[ray.wurlod]

Otherwise you can use the STATUS statement in a Routine activity to return the modification date (and lots of other information about the file).

[chulett]

And I would suggest you always start the Sequence job and then, depending on the date check, decide if the rest of it can run or if you need to send your warning out.