Из QA пытаюсь выполнить следующее:

USE db_users

IF EXISTS (SELECT * FROM sysobjects WHERE name='spStartSessionChecking' AND type='P')
DROP PROCEDURE spStartSessionChecking
GO

CREATE PROCEDURE spStartSessionChecking
AS
EXEC sp_add_job
@job_name='jbSessionChecking'

EXEC sp_add_jobstep
@job_name='jbSessionChecking',
@subsystem = 'TSQL',
@command = 'exec spCheckUsersSessions'

EXEC sp_add_jobschedule
@job_name='jbSessionChecking',
@freq_type = 4,
@freq_interval = 1,
@freq_subday_type = 0x4,
@freq_subday_interval = 10

GO

IF EXISTS (SELECT * FROM sysobjects WHERE name='spEndSessionChecking' AND type='P')
DROP PROCEDURE spEndSessionChecking
GO

CREATE PROCEDURE spEndSessionChecking
AS
EXEC sp_delete_job
@job_name='jbSessionChecking'

GO

----------------------
Получаю:

Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_add_job'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_add_jobstep'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_add_jobschedule'. The stored procedure will still be created.
Cannot add rows to sysdepends for the current stored procedure because it depends on the missing object 'sp_delete_job'. The stored procedure will still be created.

-----------

why and how?

great thanks for every comment

Спасибо, Epanch и Глеб!