• komal145 (10/20/2016)


    ...My dba has to run job manually if there is no data. Is there a way to do it?

    Do you mean the DBA must (re-)start the job if there were no files/data to load (e.g. source)? Or does he need to (re-)run the job when no data was loaded in the database tables (e.g. destination)?

    If a re-run is required because missing source data: I suggest to build checks into the package to check the source before proceding. Or build better error-handling in the package to prevent an error if no data is processed.

    If a re-run is required becuase of missing destination data: I suggest to build an extra job and schedule it to run after the job with the packages has finished. In this new job you check the results in the destination and re-start the job with the packages if there is no data.

    ** Don't mistake the ‘stupidity of the crowd’ for the ‘wisdom of the group’! **