Want to freeze one user account, before want to know how many jobs(process builder, workflow, batch job everything) are running by the user?
Any type of suggestion or SOQL statement will be helpful.
Salesforce Stack Exchange is a question and answer site for Salesforce administrators, implementation experts, developers and anybody in-between. It only takes a minute to sign up.Sign up to join this community
I would have to ask why you needed to know this?
In order to gracefully allow pending processing to be performed you should first freeze the account and only later deactivate it (freezing simply disallows login but existing jobs for the user can continue to run).
Note, however, that there is one set of processes you definitely need to look for; scheduled jobs owned by that user (CronTrigger records). You must deal with moving these to a different user as needed. This includes scheduled batches, scheduled apex and scheduled flows, as can be determined using the CronJobDetail record associated with the CronTrigger record.
This is non-trivial, since you won't necessarily know the internal state for these jobs (e.g. the members of the Batchable that is scheduled) and cannot access it. Scheduled jobs will typically be easier to deal with since your app will usually only have a handful of such jobs.