How to generate the schema for the logs as follows:?
Job scenario:
csv file to postgresql
I need to extract basic information about a job every time its run and output this into a DB. I need this information such as the following to link to the schema of the table(log_table) in my database. How would I do that?
I was not able to change the schema of the tStatCatcher to match with my database schema.
my db log_Table_schema
Username - of the person running the Job job id: int Job Name: varchar
Creation on: Datetime
created by: int
updated on:
updated by: Result ? Success or Failure.
and maybe some other entities. How would I create this Job very simply?
Hi The schema of tStatCatcher is read only, however, you can link it to a tMap and then add/remove/update columns on tMap to match your target table schema.
Question 1. I tried using that. But how do I get data like username, updated by, updated to those defined variables.
Also, let's say user1 created the data and when user2 updates the data two days later, the record should show like
created by user1
created on 11/04/19
updated by user2
updated on 11/06/19
Question 2. I created the project in the below manner
proj_name: psql
job_name: Odoo_crashing
Table schema: daily_visibility
Now I need to pull that table schema name as well during my tStatCtacher along with all the other parameters(user,created by, created on, updated by, updated on and so on..)
Hi Ravi Question1: it is impossible to know who will run the job, unless you let the job to ask for the username in the beginning of job (using tMsbBox with question button or fetch this username from somewhere?)
Question2: the table schema is the one which you use on tDBoutput component?
