Unable to find "Cancel Expired Assessments" in sysauto table while I can find it in sys_trigger

sumol
Giga Expert

Hi team,

I had few queries on the OOB scheduled job - "Cancel Expired Assessments", can you help me with the below queries?

  1. One of the requirement is to disable this job, what are the consequences if we were to disable it? Is it recommended?
  2. I am unable to find this job in sysauto table but it is available in sys_trigger. Is there a way I can edit this job from sysauto table?

Thanks in advance,

Sumol S.

3 REPLIES 3

Mahak2
Kilo Guru

Hello,

Basically this scheduled job will Cancel all Surveys that have a Due date that is in the past/breached.

Depending on your requirements you can update this.

Also please refer below articles:

https://community.servicenow.com/community?id=community_question&sys_id=0a6660c81b1e5850d2ccea89bd4bcb6a

https://community.servicenow.com/community?id=community_question&sys_id=b5434fe1dbd8dbc01dcaf3231f961935

In order to stop running this job you can set the "Trigger type" to On demand instead of Interval.

Please mark reply as Helpful/Correct, if applicable. Thanks!

Good Day,

Did this script previously execute off of the Expiration Date field instead (which would also make more sense, given the name of the script)? 

In the past, we wrote code that would extend the expiration date to a year out so that it wouldn't get canceled so quickly by the automated script, and this solved our problem -- until late last month. Seems that, with one of the recent San Diego changes, this script is now executing against the Due Date value, which is very problematic for a number of reasons.

Would appreciate any information/insight you have regarding this.

Thanks!

Community Alums
Not applicable

Hi @sumol ,

Cancel Expired Assessments scheduled job sets the surveys to be expired and by default, it only runs once every 30 days.

Here are your answers:

1. You cannot disable is firstly, as this is confined with ServiceNow.

2. sys_trigger holds which schedule job would be running next and sysauto holds the script for the schedule job. Since Cancel Expired Assessments is not available for customers, you cannot see it available in sys_auto.

Mark my answer correct & Helpful, if Applicable.

Thanks,
Sandeep