How to turn off the Global Scheduled Services through SQL query in Primavera P6 

In this section, we will see how to turn Off or On the following Global Scheduled Services through Oracle SQL Query 

 

Global_Scheduled_Services How to turn Off the Global Scheduled Services through SQL Query in Primavera P6

 

  1. Log into ADMUSER account. The following query list the 5 Global Scheduled Services 

 

select * from admuser.jobsvc where job_type in (‘JT_Security’,’JT_EnterpriseData’,’JT_EnterpriseSum’,’JT_ResourceMgmt’,’JT_AuditData’)

 

Global_Scheduled_Services1 How to turn Off the Global Scheduled Services through SQL Query in Primavera P6

 

 

2. The following query Uncheck the Publish Security in Global Scheduled Services . Replace the JT_Security with any other services you want to uncheck 

 

Login to ADMUSER

update jobsvc set recur_type = ‘RT_RecurDisabled’ where job_type = ‘JT_Security’;

commit;

 

3. Run the following query to check back again 

Login to ADMUSER 

 

update jobsvc set recur_type = ‘RT_WebEnabled’ where job_type = ‘JT_Security’;

commit;

 

 

 

 

 

govindan How to turn Off the Global Scheduled Services through SQL Query in Primavera P6
Connect me

Govind

Thank you for visiting my personal blog. Myself Govindan, Software Developer by profession since 2006 and hence I started this blog early in 2016 and ever since I've been writing about technologies experienced and learnings of everyday life.

The views expressed on this blog are my personal views and do not necessarily reflect the views of my employer.

Please feeling free to reach me on any comments and feedbacks you have. Would be more than glad to listen and reply šŸ™‚
govindan How to turn Off the Global Scheduled Services through SQL Query in Primavera P6
Connect me
By | 2019-08-17T00:16:28+00:00 August 16th, 2019|Categories: P6|Tags: |Comments Off on How to turn Off the Global Scheduled Services through SQL Query in Primavera P6
Like us on Facebook.
Connect!