Select your user interface:

Create Job Schedule Action

Clicking the Create Job Schedule action on a business process status page opens the Business Process Job Add Form which is a data form that ships with Blackbaud CRM.  

Figure: Business Process Job Add Form

When the data form is saved, the data form's save implementation code (business logic layer) will create a SQL job to execute the business process using a specific parameter set.  The creation of the SQL job is a two-step process:

  1. When the data form is saved, a business process SQL job script is generated using the ID of the business process, the ID of the parameter set. A SQL job will call upon this script to execute the business process. The generated script can be used to make a web request to execute a business process. The web request consists of a URL that includes a query string that contains the database name, business process ID, and parameter set ID.

  2. After the script is built, the script text is passed to a call to the USP_BUSINESSPROCESSJOBSCHEDULE_ADD stored procedure along with the job name, description, and schedule information. USP_BUSINESSPROCESSJOBSCHEDULE_ADD calls upon the sp_add_job, sp_add_jobstep, sp_add_jobschedule, and sp_add_jobserver stored procedures that ship with SQL Server.  sp_add_job adds a new job executed by the SQLServerAgent service. After sp_add_job is executed to add a job, sp_add_jobstep can be used to add steps that perform the activities for the job. sp_add_jobstep adds a step (operation) named "Business process invoke" to the job. It is in the call to sp_add_jobstep that the generated script is passed through the @COMMAND parameter. sp_add_jobschedule can be used to create the schedule that the SQL Server Agent service uses to execute the job.   sp_add_jobserver sets the SQL Server instance where the job executes.