My situation is On year end a table get flushed out in one of the job. Before that job I want to run my job. So that I can get the records. But I am not sure which job is flushed out the table. My program is using sql query to fetch those records from that table
Anyone please help me to give idea.
"Flushed" is a bad word to use - you actually mean "empty". A flushed jb is one that has failed badly on submission and before execution. One that starts and fails has "flushed" (i.e. not executed) steps.