This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Dump process step logs to a server

Hello,

We have a custom process to disable users if their termdate is past. Below is the where clause

Dim f As ISqlFormatter = Connection.SqlFormatter

Value = f.AndRelation(f.Comparison("IsTemporaryDeactivated", False, ValType.Bool, CompareOperator.Equal, FormatterOptions.None), _

f.Comparison("IsInActive", False, ValType.Bool, CompareOperator.Equal, FormatterOptions.None), _

f.Comparison("CCC_TMDATE", Date.Now.Date, ValType.Date, CompareOperator.LowerThan, FormatterOptions.None), _

f.Comparison("CCC_TMDATE", DBVal.MinDate, ValType.Date, CompareOperator.GreaterThan, FormatterOptions.None))

We want to dump all the users that were disabled based on above to a file on the job server. How do we go about doing this? Please advise

Thanks in advance

Parents Reply
  • Yes, it is possible. Please keep in mind that the values of the process step parameters are generated by code expression. Your filename parameter just needs to add the current datetime at generation time to the filename.

    Value = String.Format("MyFileName-{0:s}", DateTime.UtcNow)

    The format specifier s indicates a sortable datetime pattern.

    You can test the result in the Simulation Mode of the process editor in Designer.

Children