Bulk updates for run books, events, etc

[dcgriffin]

I'm looking for information on how to do bulk updates of all (or a portion of) the run books for jobs. We've had a change of contact that is currently included in all of our run books and would like to be able to replace it in bulk rather than editing each separate job. Can this be done through some type of database update? Also is there anything similar for adding a particular event/action to all (or some) jobs without editing each individual job? Any information would be helpful and appreciated. Thanks

[opsteamprod1]

You can add multiple jobs to a job event by clicking on the Associated Jobs tab.  And all jobs will have the same action you define under the Associated Actions tab.

[jeff.hamway01]

Just started this today.  I also need to update ALL runbooks in the environment.  I am having some difficulties with a SQL statement to make this work.

so far im using:

UPDATE Admiraldev.dbo.jobmst

SET jobmst_runbook='http://www.google.com'

Where jobmst_prntname LIKE 'Financials'

However,  the results are the admiral DB gets updated but the client does not show the update.

1.  I have restarted the Client and Database server

I think I have 2 issues.

1. How do I get the 'Load URL' option selected

2. do I somehow have to trick the DB to change the 'last modified date'?

thanks in advance for your assistance. 

[dcgriffin]

According to a cisco tech:

Disclaimer:

Direct modification of the Tidal database is not supported.

The runbook information is stored in both the admiral and tescache db’s

admiral db

jobmst table

jobmst_runbook column

Tescache db

Tes.job table

Runbook column

I haven't gotten around to trying anything yet as other things have taken priority but that's the information I was given. Hope it helps

From first glance you probably either have to clear the cache database and repopulate it or change it in both places.