Вот это не работает
USE [test14]
CREATE TABLE [dbo].[1](
[i] [int] NULL
) ON [PRIMARY]
GO
DECLARE @job varchar(400)
set @job = N'Test15'
EXEC msdb.dbo.sp_add_job @job_name = @job
DECLARE @step varchar(400)
set @step = @job + N' Step1 only'
EXEC msdb.dbo.sp_add_jobstep
@job_name = @job,
@step_name = @step,
@subsystem = N'TSQL',
@command = N'use [test14] ;
go
insert into test14.dbo.[1] values (777)',
@retry_attempts = 2,
@retry_interval = 5 ;
DECLARE @schedule varchar(400)
set @schedule = @job + N'schedule'
EXEC msdb.dbo.sp_add_jobschedule @job_name = @job,
@name = @schedule,
@freq_type = 4, -- Daily
@freq_interval = 4, --(daily)
@freq_subday_type = 0x4, -- Minutes
@freq_subday_interval = 1, -- every minute
@active_start_time = 010101, -- past
@active_start_date = 19900101 ; -- past
Может я ещё чего то не знаю...
P.S. MSSQL 2005, Windows Authentication