background script - how to turn off debug ouput starting with "Time: 0:00: ..."

[stephane9]

Hi,

When I execute a background script which takes a bit of time to execute, I get some output added that look like some debug/trace such as below:

NOTE: If the script executes rapidly, I don't get this output ( e.g. one of my script calculate the number of records in some named tables and thus runs fast on some instances with few records and takes time in other instances with lots of records)

Time: 0:00:01.059 id: <instance> [glide.11] primary_hash=-1735923005 (connpid=900419) for: SELECT count(*) AS recordcount FROM sys_audit sys_audit0  /* ociomyscstaging013, gs:2C7A6EB1474679107BBD6DA7A46D43BE, tx:219c3afd474679107bbd6da7a46d435e, hash:-1735923005 */ 

I have checked a few thread and none seem to have the fix.

I tried to add a new property to set glide.db.trace to false but same output.

Does anyone know how to silence this?

[Musab Rasheed]

Hello,

I think this is not possible, if you are using Company's instance you can create HI ticket with servicenow support team and get the confirmation.

[stephane9 · Accepted solution]

So I logged a call with SN and they confirmed there is no configuration option to suppress the information message on long running queries, which is an OOB functionality.

They suggested to create an case on the idea portal, which I did so if you are interested in the same, please upvote this idea so that it gets some attention as otherwise it's just going to be ignored as per their process.

link to idea: here

Name: "allow suppression of extra information on long queries when using background scripts"