Inactivate catalog item with a scheduled job script

[will_smith]

I have a simple scheduled job script that I want to inactivate a record producer catalog item at a specific time. Below is my script, but the active flag is still checked when I execute it. I have ran this through a background script by adding gs.print statements and it says the flag is flipping to false. Could someone please tell me what I am missing here?

var PwdResetCatItem = new GlideRecord('sc_cat_item');
PwdResetCatItem.addQuery('name','Password Reset');
PwdResetCatItem.addActiveQuery();
PwdResetCatItem.query();
while (PwdResetCatItem.next()) { // if the catalog item is still active, inactivate it
   PwdResetCatItem.setValue('active',false);
}

[Uncle Rob]

Insert line between row 8 and 9

PwdResetCatItem.update();

EDIT:   Beat me by a second!

[will_smith]

Now I just have to work out a notification for this change...

[will_smith]

When I move this to production, management wants to know it was done.

As a test in my demo environment, I disabled a catalog item with a class of catalog item and that fired off a notification. So, it has something to do with the fact that this is a record producer - which appears to be on a different table.

[will_smith]

Fixed it!

Changed the table from Catalog Item to Record Producer. I also added a name, so that it only triggers on this particular one.

Thanks again Robert for helping me out on this.