# USing

**URL:** <https://matillioncommunity.discourse.group/t/using/1859>\
**Category:** Matillion ETL\
**Created:** [August 23, 2022, 3:53pm UTC](https://matillioncommunity.discourse.group/t/using/1859 "2022-08-23T15:53:05Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![S2022](https://avatars.discourse-cdn.com/v4/letter/s/54ee81/32.png) [@S2022](https://matillioncommunity.discourse.group/u/S2022)\
**Post date:** [August 23, 2022, 3:53pm UTC](https://matillioncommunity.discourse.group/t/using/1859/1 "2022-08-23T15:53:05Z")

</div>

Can we capture job start and end time and row count using job variables.

&nbsp;

Assigning start\_time , row\_count to variables and inserting to snowflake table.

but job values are not being loaded . I see nulls in snowflake table.

&nbsp;

Any help?

&nbsp;

Thanks.

&nbsp;

&nbsp;

&nbsp;

---

<div class="post-metadata">

**Author:** ![ganesh\_pitchai](https://avatars.discourse-cdn.com/v4/letter/g/67e7ee/32.png) [@ganesh\_pitchai](https://matillioncommunity.discourse.group/u/ganesh_pitchai)\
**Post date:** [August 23, 2022, 4:46pm UTC](https://matillioncommunity.discourse.group/t/using/1859/2 "2022-08-23T16:46:48Z")

</div>

Hi if you expect this for audit purpose you can make sql script to update before start and end time after success.​

​

For row count i found this in forum please check if it helps ​[https://matillioncommunity.discourse.group/t/hi-guys-what-tools-in-matillion-can-i-use-get-a-row-count-of-all-the-tables-in-a-snowflake-schema-without-using-the-information-schema/1579](https://matillioncommunity.discourse.group/t/hi-guys-what-tools-in-matillion-can-i-use-get-a-row-count-of-all-the-tables-in-a-snowflake-schema-without-using-the-information-schema/1579)

---

<div class="post-metadata">

**Author:** ![AnudeepK](https://avatars.discourse-cdn.com/v4/letter/a/e36b37/32.png) [@AnudeepK](https://matillioncommunity.discourse.group/u/AnudeepK)\
**Post date:** [September 16, 2022, 2:05am UTC](https://matillioncommunity.discourse.group/t/using/1859/3 "2022-09-16T02:05:43Z")

</div>

The best way to get this audit information would be exploring Task History API. Matillion already records Start Time, End Time, Duration and Row Count and Message information for every task executed in its Postgres Database.

&nbsp;

Calling TaskHistory API and recording the data into a Snowflake table would be an easier option , I reckon.

&nbsp;

The Other possible way is to use a Shared Job which fetches and logs the values into a Table. And every Orchestration/Transformation job needs to be run via this Shared Job.