SLAM_list_jobs

Overview

Lists all of the bulk query and load jobs (most recent first). This can be used to audit the Salesforce bulk job history, or to identify a job id to pass to SLAM_download_job

Usage Example

EXEC dbo.SLAM_list_jobs;

Example Output:

Version: x.x.x; Build: xxxxxxxxxx [xxxxxx] (xxxxxxxxxxxxx)
Process ID: 13392
Listing all bulk jobs for username@domain.com
id: 750Ho00000cyZJfIAM
operation: query
object: Account
createdById: 0058a00000KcKLRAA3
createdDate: 2025-11-01T18:25:02.000+0000
systemModstamp: 2025-11-01T18:25:09.000+0000
state: Closed
concurrencyMode: Serial
contentType: CSV
apiVersion: 60.0
jobType: Classic
lineEnding: CRLF
 
id: 750Ho00000cyZJfIAM
operation: query
object: Account
createdById: 0058a00000KcKLRAA3
createdDate: 2025-11-01T18:25:01.000+0000
systemModstamp: 2025-11-01T18:25:01.000+0000
...