How to restore missing Cireson Analytics SQL agent jobs after database migration to new server
I have SQL agent jobs missing after moving Cireson Analytics database to the other server and then moving database back to new 2016 server.
It was a part of Service manager database migration to 2016 environment project.
I have followed Cireson instructions here https://support.cireson.com/KnowledgeBase/View/1202#/
with one exception. I did not run the installer for Cireson Portal again. I just pointed the cache builder to restored Service Management database on other server. After moving databases back, Cireson portal is fully functional.
However, only four out of nineteen Cireson Analytics SQL agent jobs are present.
Is there a way to restore missing jobs by executing stored procedure if there is one present in database?
Or restore jobs by running specific for Cireson Analytics installation file?
Please, see screenshots above.