USP_ADD_SQLJOB_SCHEDULES
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @BUSINESSPROCESSID | uniqueidentifier | IN | |
| @JOBNAME | nvarchar(400) | IN | |
| @DESCRIPTION | nvarchar(500) | IN | |
| @SCHEDULEFREQUENCYTYPE | int | IN | |
| @SCHEDULEONCEDATE | datetime | IN | |
| @SCHEDULEONCETIME | datetime | IN | |
| @SCHEDULEFREQUENCYMONTHLYINTERVAL | int | IN | |
| @SCHEDULEFREQUENCYEVERY | int | IN | |
| @SCHEDULEFREQUENCYINTERVAL | int | IN | |
| @SCHEDULEWEEKLYMONDAY | bit | IN | |
| @SCHEDULEWEEKLYTUESDAY | bit | IN | |
| @SCHEDULEWEEKLYWEDNESDAY | bit | IN | |
| @SCHEDULEWEEKLYTHURSDAY | bit | IN | |
| @SCHEDULEWEEKLYFRIDAY | bit | IN | |
| @SCHEDULEWEEKLYSATURDAY | bit | IN | |
| @SCHEDULEWEEKLYSUNDAY | bit | IN | |
| @SCHEDULEFREQUENCYMONTHLYISRELATIVE | bit | IN | |
| @ENABLESCHEDULE | bit | IN | |
| @SCHEDULEFREQUENCYMONTHLYRELATIVEINTERVAL | int | IN | |
| @SCHEDULEFREQUENCYMONTHLYRELATIVEFREQUENCY | int | IN | |
| @SCHEDULEFREQUENCYSUBDAYTYPE | int | IN | |
| @SCHEDULEFREQUENCYSUBDAYISRELATIVE | bit | IN | |
| @SCHEDULEFREQUENCYSUBDAYINTERVAL | int | IN | |
| @SCHEDULEACTIVESTARTTIME | time | IN | |
| @SCHEDULEACTIVEENDTIME | time | IN | |
| @SCHEDULEACTIVESTARTDATE | date | IN | |
| @SCHEDULEACTIVEENDDATE | date | IN | |
| @SCHEDULENOENDDATE | bit | IN | |
| @RECORDID | int | IN | |
| @ONHEARTBEAT | bit | IN |
Definition
Copy
create procedure dbo.USP_ADD_SQLJOB_SCHEDULES (
@BUSINESSPROCESSID as uniqueidentifier
, @JOBNAME nvarchar(400)
, @DESCRIPTION nvarchar(500)
, @SCHEDULEFREQUENCYTYPE int
, @SCHEDULEONCEDATE datetime
, @SCHEDULEONCETIME datetime
, @SCHEDULEFREQUENCYMONTHLYINTERVAL int
, @SCHEDULEFREQUENCYEVERY int
, @SCHEDULEFREQUENCYINTERVAL int
, @SCHEDULEWEEKLYMONDAY bit
, @SCHEDULEWEEKLYTUESDAY bit
, @SCHEDULEWEEKLYWEDNESDAY bit
, @SCHEDULEWEEKLYTHURSDAY bit
, @SCHEDULEWEEKLYFRIDAY bit
, @SCHEDULEWEEKLYSATURDAY bit
, @SCHEDULEWEEKLYSUNDAY bit
, @SCHEDULEFREQUENCYMONTHLYISRELATIVE bit
, @ENABLESCHEDULE bit
, @SCHEDULEFREQUENCYMONTHLYRELATIVEINTERVAL int
, @SCHEDULEFREQUENCYMONTHLYRELATIVEFREQUENCY int
, @SCHEDULEFREQUENCYSUBDAYTYPE int
, @SCHEDULEFREQUENCYSUBDAYISRELATIVE bit
, @SCHEDULEFREQUENCYSUBDAYINTERVAL int
, @SCHEDULEACTIVESTARTTIME time
, @SCHEDULEACTIVEENDTIME time
, @SCHEDULEACTIVESTARTDATE date
, @SCHEDULEACTIVEENDDATE date
, @SCHEDULENOENDDATE bit
, @RECORDID int
, @ONHEARTBEAT bit
)
as
begin
DECLARE @CHANGEAGENTID UNIQUEIDENTIFIER
EXEC Usp_changeagent_getorcreatechangeagent @CHANGEAGENTID out;
if exists (select 1 from dbo.CMSSQLJOBSCHEDULES where BUSINESSPROCESSID = @BUSINESSPROCESSID)
begin
update dbo.CMSSQLJOBSCHEDULES set
BUSINESSPROCESSID=@BUSINESSPROCESSID
,JOBNAME =@JOBNAME
,DESCRIPTION =@DESCRIPTION
,SCHEDULEFREQUENCYTYPE =@SCHEDULEFREQUENCYTYPE
,SCHEDULEONCEDATE =@SCHEDULEONCEDATE
,SCHEDULEONCETIME =@SCHEDULEONCETIME
,SCHEDULEFREQUENCYMONTHLYINTERVAL=@SCHEDULEFREQUENCYMONTHLYINTERVAL
,SCHEDULEFREQUENCYEVERY=@SCHEDULEFREQUENCYEVERY
,SCHEDULEFREQUENCYINTERVAL=@SCHEDULEFREQUENCYINTERVAL
,SCHEDULEWEEKLYMONDAY=@SCHEDULEWEEKLYMONDAY
,SCHEDULEWEEKLYTUESDAY=@SCHEDULEWEEKLYTUESDAY
,SCHEDULEWEEKLYWEDNESDAY=@SCHEDULEWEEKLYWEDNESDAY
,SCHEDULEWEEKLYTHURSDAY=@SCHEDULEWEEKLYTHURSDAY
,SCHEDULEWEEKLYFRIDAY=@SCHEDULEWEEKLYFRIDAY
,SCHEDULEWEEKLYSATURDAY=@SCHEDULEWEEKLYSATURDAY
,SCHEDULEWEEKLYSUNDAY=@SCHEDULEWEEKLYSUNDAY
,SCHEDULEFREQUENCYMONTHLYISRELATIVE=@SCHEDULEFREQUENCYMONTHLYISRELATIVE
,ENABLESCHEDULE=@ENABLESCHEDULE
,SCHEDULEFREQUENCYMONTHLYRELATIVEINTERVAL=@SCHEDULEFREQUENCYMONTHLYRELATIVEINTERVAL
,SCHEDULEFREQUENCYMONTHLYRELATIVEFREQUENCY=@SCHEDULEFREQUENCYMONTHLYRELATIVEFREQUENCY
,SCHEDULEFREQUENCYSUBDAYTYPE=@SCHEDULEFREQUENCYSUBDAYTYPE
,SCHEDULEFREQUENCYSUBDAYISRELATIVE=@SCHEDULEFREQUENCYSUBDAYISRELATIVE
,SCHEDULEFREQUENCYSUBDAYINTERVAL=@SCHEDULEFREQUENCYSUBDAYINTERVAL
,SCHEDULEACTIVESTARTTIME=@SCHEDULEACTIVESTARTTIME
,SCHEDULEACTIVEENDTIME=@SCHEDULEACTIVEENDTIME
,SCHEDULEACTIVESTARTDATE=@SCHEDULEACTIVESTARTDATE
,SCHEDULEACTIVEENDDATE=@SCHEDULEACTIVEENDDATE
,SCHEDULENOENDDATE=@SCHEDULENOENDDATE
,RECORDID = @RECORDID
,ADDEDBYID=@CHANGEAGENTID
,CHANGEDBYID=@CHANGEAGENTID
,ONHEARTBEAT =@ONHEARTBEAT
where BUSINESSPROCESSID = @BUSINESSPROCESSID
end
else
begin
insert into dbo.CMSSQLJOBSCHEDULES
(
BUSINESSPROCESSID
,JOBNAME
,DESCRIPTION
,SCHEDULEFREQUENCYTYPE
,SCHEDULEONCEDATE
,SCHEDULEONCETIME
,SCHEDULEFREQUENCYMONTHLYINTERVAL
,SCHEDULEFREQUENCYEVERY
,SCHEDULEFREQUENCYINTERVAL
,SCHEDULEWEEKLYMONDAY
,SCHEDULEWEEKLYTUESDAY
,SCHEDULEWEEKLYWEDNESDAY
,SCHEDULEWEEKLYTHURSDAY
,SCHEDULEWEEKLYFRIDAY
,SCHEDULEWEEKLYSATURDAY
,SCHEDULEWEEKLYSUNDAY
,SCHEDULEFREQUENCYMONTHLYISRELATIVE
,ENABLESCHEDULE
,SCHEDULEFREQUENCYMONTHLYRELATIVEINTERVAL
,SCHEDULEFREQUENCYMONTHLYRELATIVEFREQUENCY
,SCHEDULEFREQUENCYSUBDAYTYPE
,SCHEDULEFREQUENCYSUBDAYISRELATIVE
,SCHEDULEFREQUENCYSUBDAYINTERVAL
,SCHEDULEACTIVESTARTTIME
,SCHEDULEACTIVEENDTIME
,SCHEDULEACTIVESTARTDATE
,SCHEDULEACTIVEENDDATE
,SCHEDULENOENDDATE
,RECORDID
,ADDEDBYID
,CHANGEDBYID
,ONHEARTBEAT
) values
(
@BUSINESSPROCESSID
,@JOBNAME
,@DESCRIPTION
,@SCHEDULEFREQUENCYTYPE
,@SCHEDULEONCEDATE
,@SCHEDULEONCETIME
,@SCHEDULEFREQUENCYMONTHLYINTERVAL
,@SCHEDULEFREQUENCYEVERY
,@SCHEDULEFREQUENCYINTERVAL
,@SCHEDULEWEEKLYMONDAY
,@SCHEDULEWEEKLYTUESDAY
,@SCHEDULEWEEKLYWEDNESDAY
,@SCHEDULEWEEKLYTHURSDAY
,@SCHEDULEWEEKLYFRIDAY
,@SCHEDULEWEEKLYSATURDAY
,@SCHEDULEWEEKLYSUNDAY
,@SCHEDULEFREQUENCYMONTHLYISRELATIVE
,@ENABLESCHEDULE
,@SCHEDULEFREQUENCYMONTHLYRELATIVEINTERVAL
,@SCHEDULEFREQUENCYMONTHLYRELATIVEFREQUENCY
,@SCHEDULEFREQUENCYSUBDAYTYPE
,@SCHEDULEFREQUENCYSUBDAYISRELATIVE
,@SCHEDULEFREQUENCYSUBDAYINTERVAL
,@SCHEDULEACTIVESTARTTIME
,@SCHEDULEACTIVEENDTIME
,@SCHEDULEACTIVESTARTDATE
,@SCHEDULEACTIVEENDDATE
,@SCHEDULENOENDDATE
,@RECORDID
,@CHANGEAGENTID
,@CHANGEAGENTID
,@ONHEARTBEAT
)
end
end