Script to gather information from job tables
Change variables as necessary
@AllJobHistory --0 for current jobs 1 for history (tblasyncjobqueue or tblasyncinstrumentation)
@OnlyRunningJob s-- 1 for only running jobs
@OnlyAvailableJobs -- 1 for only available jobs
@OnlyWaitingJob s-- 1 for only waiting for schedule jobs
@topx -- top x of rows from table 9223372036854775807 is max
@FilterByJobType --job filter do not include % leave as empty string ('') for all job types
If columns are empty for a job but other similar job types are populated typically means the job is orphaned somewhere along the line
For example scheduled data feed job for a data feed id that does not have a level_id or module_id, data feed is probably missing
The resulting table #jobDetail can be utilized for additional analysis
This is not an officially RSA supported script.
It is provided as is.
Suitable precautions should be taken for your environment such as, but not limited to, backing up any related data
20190106 Initial Release
20190115 Filtering fixes and additional columns
20190205 Fixed column population
Added/modified columns to handle jobs with multiple entries
improved filtering options
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.