UC4 JOB Deactivation at Database level using query

[Karthikkumar M]

Team,

Our UC4 Production copy from other UC4 Production system, currently we want to deactivate 9000+ jobs which is not required for us.
Manually job deactivation is time consuming so we want to disable at SQL Database level, Is there any query to perform this tasks?

Regards

Karthik.M

[Alexander Trenker]

Hi @Karthikkumar M,

Please open a Support case and provide the Automic version and database product. Then we can send a cleanup script for your environment.

Cheers,
Alexander​

[Karthikkumar M]

Hi Alexander,

Thanks for immediate replay.
Please find as below version of UC4 System, I am not sure how to open a support case, Kindly help me on this.

Product: Automatic version: 2013

Database : MS SQL 2012( 10.0.75)

Regards

Karthikkumar.M

[Pete Wirfs]

I use this link to access my support cases;

https://ca-broadcom.wolkenservicedesk.com/esd/allcases

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Karthikkumar M]

Hello Pete,

Using the link i am trying to accessing support case i am received error as "Grant not available, Please contact admin".
Screenshot is also attached for your reference,
Kindly help us to access the link.

Regards

Karthik.M

[Pete Wirfs]

Perhaps one of these telephone numbers would help you?

https://community.broadcom.com/communities/community-home/digestviewer/viewthread?MID=810887

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Karthikkumar M]

Hi Pete,

We are unable to reach as mentioned telephone number, This Job deactivation is time consuming tasks and critical request also, Could you please share any email details to reach out to technical team.

Thanks for your support.

Regards

Karthik.M

[Pete Wirfs]

Technical Support <[e-mail]>

------------------------------
Pete Wirfs
SAIF Corporation
Salem Oregon USA
------------------------------

[Karthikkumar M]

Thanks, Pete I sent the mail to technical. Support team, the screenshot is attached for reference.
 I am waiting for your response. 

Regards

Karthik.M

[Joel Wiesmann]

No need for a support case and risky SQL statements. Just use DEACTIVATE_UC_OBJECT. As input you might go for a SQL(I) VARA that does a query on the EH table on all records with status code >= 1800. You might have a limit that the SQLI only returns 300 records - you could increase that or just query as long as there are records coming back from the VARA.

https://docs.automic.com/documentation/webhelp/english/AA/12.3/DOCU/12.3/Automic%20Automation%20Guides/help.htm#Script/Reference/DEACTIVATE_UC_OBJECT.htm?Highlight=deactivate

------------------------------
☎️ Swisscom Automation Engineer & 🧙 PE Membership Creator

Automic Kurse, Tutorials, Tools und mehr auf:
https://membership.philippelmer.com/
Zwei Wochen kostenlos testen!
------------------------------

[Karthikkumar M]

Hi Joel,

We have checked the above thread but we are not clear to deactivate the jobs in UC4 system. Kindly provide us the detailed procedure of mass deactivation of Jobs in UC4. Currently we are following manually procedure to deactivate the jobs. There are 7000+ jo which needs to deactivate in Production system. Please find the the steps of our procedure of deactivation.

[Joel Wiesmann]

Ah you want to INACTIVATE, not DEACTIVATE. This is in the Automic jargon two different things.

In this case you would need a mass mutation of the impacted objects. In the instruction above you are inactivating the tasks in the workflow, wouldn't it be easier to inactivate the objects itself? There is a flag for this in the headers tab.

------------------------------
☎️ Swisscom Automation Engineer & 🧙 PE Membership Creator

Automic Kurse, Tutorials, Tools und mehr auf:
https://membership.philippelmer.com/
Zwei Wochen kostenlos testen!
------------------------------

[Karthikkumar M]

Hi Joel,

Thanks for the reply. Can you please provide us more details related to it.

[Karthikkumar M]

Hi Joel,

This is a Production issue Can you please check and revert back ASAP.
Thanks for your support, 

Regards

Karthik.M

[Christoph Rekers]

@Karthikkumar M,

You might have missed that this is a forum of voluntiers. That means most of the people writing content, do that in their working hours or even spare time.​ So it doesn't make sense to demand an answer "ASAP". If you need immideate help, you or the company you work for, might want to either contact the Broadcom support team or buy help from an external partner.

Cheers
Christoph

------------------------------
----------------------------------------------------------------
Automic AE Consultant and Trainer since 2000
----------------------------------------------------------------
------------------------------

[Karthikkumar M]

Hi Christoph, 

I thought this forum is managed by UC4 Team, now I understood this will be managed by volunteers, sorry for my previous posting I was mentioned that "ASAP". 

Regards

KarthiK.M

[Karthikkumar M]

Team,
Please update my query if anyone knows this solution for the Mass Job deactivation process.
This will be greatly helpful for us.
Regards
Karthik.M

[Joel Wiesmann]

Hi Karthik

If you want to get a solution that modifies the database, try it with a support ticket.

For any other solutions it requires some effort to create a solution. This is likely extending the willingness of free community support.

> If you are on a modern Automic version (12.2+) you might go with a python script that does object export/import via REST.
> For any version before 12.2 you would go for a Java Application that you would need to programm using the ApplicationInterface. This could modify the objects online without any export/import logic. There is also a Powershell-based module I wrote that could achieve this task - but this isn't freely available.
> Maybe it would also be possible to use AE Script EXPORT & IMPORT statements together with the XML functions, but this is likely not a task for a beginner (no offense).
> Last but not least it might be possible to do this with the transport case related tools. I haven't been working with them so I can not give a deeper advice.

------------------------------
☎️ Swisscom Automation Engineer & 🧙 PE Membership Creator

Automic Kurse, Tutorials, Tools und mehr auf:
https://membership.philippelmer.com/
Zwei Wochen kostenlos testen!
------------------------------