DBI_Activate_Restart

Overview

The metadata table called DBI_Activate_Restart allows for the re-execution of jobs defined in the DBI_Activate table.  This is designed as to NOT make changes to the actual job, because many times the original changes could get lost, or you may forget to change it back.  Therefore, this process allows you to reference the job in the DBI_Activate table, and once complete and Active, the job will be triggered automaically.  No need to set the Activate_Flag back to ‘N’, as this is done automatically as soon the job is executed.

Table Rules

  • Job_Name – Job name from DBI_Activate
  • Activate_Flag (Y/N) – Set this flag to a ‘Y’ if you want to start the job.  Once the job is started, it will automatically be set to an ‘N’.
  • Restarted_By – The user who last executed this restart.  This is manually entered by the user.
  • Restart_Command_Number – provide the DBI_Activate command number from where you want to start.  This allows for the original job to start at a specific step, typically the point at which the job failed, allowing for a restart at the failed step.
  • Linux_Command – Any linux command to be executed
  • Last_Executed – Once this process is executed, the system will populate this field with the timestamp
Advertisements