Maintenance Script

[vkent39]

Is this accurate behavior for Chocolatey to create a bunch of maintenance scripts?

Chocolatey.PNG (46.97 KiB) Viewed 17560 times

[coriron]

I'm seeing this also. Going to take forever to delete them all...

[Cubert]

Nope, this is something jammed in the plugin install process during the plugin manager update.

To fix.

Disable the plugin and remove, restart the DBAgent,
Run the following command in SQLYog

Code: Select all

DELETE FROM scheduledscripts WHERE scriptid = (SELECT ScriptID FROM lt_scripts where ScriptName = '%Chocolatey%II%')

Next reinstall plugin and enable, restart the dbagent again and 1 Chocolatey For Labtech script should exist and not duplicate.

Also verify you are on the latest Chocolatey DLL as Chocolatey II is now Chocolatey for labtech.

[tobycarver]

I'm on a hosted solution for LabTech and don't have direct access to the SQL database. Any suggestions apart from manually deleting each one for this deployment?

[Cubert]

Yeap,

Use my handy dandy SQL query analyzer for LabTech, this adds the ability to execute SQL command directly. http://www.plugins4labtech.com/plugins. ... E6759999B4

[tobycarver]

Thanks. If I have the new Chocolatey plugin, do I still need to uninstall the current Chocolatey plugin before running the sql script to remove the old maintenance scripts?

[tobycarver]

OK, I went ahead and tried to run the script and it said it could not find the table. I assume the table it's referring to is "scheduledscripts". What am I doing wrong?

[Cubert]

Toby,

Remove all existing plugin_sw_chocolatey_xx tables from mySQL using SQLYog and restart the dbagent. this will fix your issues.

[tobycarver]

I do that by removing the plugin, then adding it back?

[Cubert]

nope open SQL yog and select each table and then right click and select drop table.