Thursday, June 2, 2011

Schedule JobSet Definitions

Need to Update/Delete the data from the following 7 tables:

1. PS_SCHDLDEFN
2. PS_SCHDLITEM
3. PS_SCHDLNODEPARM
4. PS_SCHDLNOTIFY
5. PS_SCHDLMESSAGE
6. PS_SCHDLDEFNINFO
7. PS_SCHDLTEXT



select 'PS_SCHDLDEFN' , * from PS_SCHDLDEFN where SCHEDULENAME like 'PRI009%'
select 'PS_SCHDLITEM' , * from PS_SCHDLITEM where SCHEDULENAME like 'PRI009%'
select 'PS_SCHDLNODEPARM' , * from PS_SCHDLNODEPARM   where SCHEDULENAME like 'PRI009%'
select 'PS_SCHDLNOTIFY' , * from PS_SCHDLNOTIFY   where SCHEDULENAME like 'PRI009%'
select 'PS_SCHDLMESSAGE' , * from PS_SCHDLMESSAGE   where SCHEDULENAME like 'PRI009%'
select 'PS_SCHDLDEFNINFO' , * from PS_SCHDLDEFNINFO   where SCHEDULENAME like 'PRI009%'
select 'PS_SCHDLTEXT' , * from PS_SCHDLTEXT   where SCHEDULENAME like 'PRI009%'

No comments:

Post a Comment

Powered By Blogger