Dependencies for System Stored Procedure: master.dbo.sp_TSQLJobCreate

ReferencingFQN ReferencingType ReferencedFQN ReferencedType Depth RedHierarchy
master.dbo.sp_TSQLJobCreate Stored procedure msdb.dbo.sp_add_job Stored procedure 1 [msdb].[dbo].[sp_add_job]
master.dbo.sp_TSQLJobCreate Stored procedure msdb.dbo.sp_add_jobserver Stored procedure 1 [msdb].[dbo].[sp_add_jobserver]
master.dbo.sp_TSQLJobCreate Stored procedure msdb.dbo.sp_add_jobstep Stored procedure 1 [msdb].[dbo].[sp_add_jobstep]
master.dbo.sp_TSQLJobCreate Stored procedure msdb.dbo.sp_delete_job Stored procedure 1 [msdb].[dbo].[sp_delete_job]
master.dbo.sp_TSQLJobCreate Stored procedure msdb.dbo.sp_update_job Stored procedure 1 [msdb].[dbo].[sp_update_job]
master.dbo.sp_TSQLJobCreate Stored procedure msdb.dbo.sysjobs Table 1 [msdb].[dbo].[sysjobs]
msdb.dbo.sp_add_job Stored procedure msdb.dbo.sysoriginatingservers_view View 2 [msdb].[dbo].[sp_add_job], [msdb].[dbo].[sysoriginatingservers_view]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.sp_sqlagent_has_server_access Stored procedure 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[sp_sqlagent_has_server_access]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.sp_sqlagent_notify Stored procedure 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[sp_sqlagent_notify]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.SQLAGENT_SUSER_SNAME SQL scalar function 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[SQLAGENT_SUSER_SNAME]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.syscategories Table 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[syscategories]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.sysjobs_view View 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[sysjobs_view]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.sysjobservers Table 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[sysjobservers]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.sysjobsteps Table 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[sysjobsteps]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.sysoperators Table 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[sysoperators]
msdb.dbo.sp_add_jobserver Stored procedure msdb.dbo.systargetservers Table 2 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[systargetservers]
msdb.dbo.sp_add_jobstep Stored procedure msdb.dbo.sp_add_jobstep_internal Stored procedure 2 [msdb].[dbo].[sp_add_jobstep], [msdb].[dbo].[sp_add_jobstep_internal]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sp_delete_all_msx_jobs Stored procedure 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_delete_all_msx_jobs]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sp_delete_job_references Stored procedure 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_delete_job_references]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sp_post_msx_operation Stored procedure 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_post_msx_operation]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sysdownloadlist Table 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sysdownloadlist]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sysjobhistory Table 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sysjobhistory]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sysjobs_view View 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sysjobs_view]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sysjobschedules Table 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sysjobschedules]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sysjobservers Table 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sysjobservers]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sysjobsteps Table 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sysjobsteps]
msdb.dbo.sp_delete_job Stored procedure msdb.dbo.sysschedules Table 2 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sysschedules]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.sp_post_msx_operation Stored procedure 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sp_post_msx_operation]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.sp_sqlagent_has_server_access Stored procedure 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sp_sqlagent_has_server_access]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.sp_sqlagent_notify Stored procedure 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sp_sqlagent_notify]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.SQLAGENT_SUSER_SNAME SQL scalar function 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[SQLAGENT_SUSER_SNAME]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.sysalerts Table 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sysalerts]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.syscategories Table 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[syscategories]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.sysjobs_view View 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sysjobs_view]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.sysjobservers Table 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sysjobservers]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.sysjobsteps Table 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sysjobsteps]
msdb.dbo.sp_update_job Stored procedure msdb.dbo.sysoperators Table 2 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sysoperators]
msdb.dbo.sp_delete_job_references Stored procedure msdb.dbo.sp_update_alert Stored procedure 3 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_delete_job_references], [msdb].[dbo].[sp_update_alert]
msdb.dbo.sp_delete_job_references Stored procedure msdb.dbo.sysdbmaintplan_jobs Table 3 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_delete_job_references], [msdb].[dbo].[sysdbmaintplan_jobs]
msdb.dbo.sp_delete_job_references Stored procedure msdb.dbo.systaskids Table 3 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_delete_job_references], [msdb].[dbo].[systaskids]
msdb.dbo.sp_post_msx_operation Stored procedure msdb.dbo.sp_downloaded_row_limiter Stored procedure 3 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sp_post_msx_operation], [msdb].[dbo].[sp_downloaded_row_limiter]
msdb.dbo.sp_post_msx_operation Stored procedure msdb.dbo.sp_downloaded_row_limiter Stored procedure 3 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_post_msx_operation], [msdb].[dbo].[sp_downloaded_row_limiter]
msdb.dbo.sp_post_msx_operation Stored procedure msdb.dbo.sysschedules_localserver_view View 3 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sp_post_msx_operation], [msdb].[dbo].[sysschedules_localserver_view]
msdb.dbo.sp_post_msx_operation Stored procedure msdb.dbo.sysschedules_localserver_view View 3 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_post_msx_operation], [msdb].[dbo].[sysschedules_localserver_view]
msdb.dbo.sp_sqlagent_has_server_access Stored procedure msdb.dbo.syscachedcredentials Table 3 [msdb].[dbo].[sp_update_job], [msdb].[dbo].[sp_sqlagent_has_server_access], [msdb].[dbo].[syscachedcredentials]
msdb.dbo.sp_sqlagent_has_server_access Stored procedure msdb.dbo.syscachedcredentials Table 3 [msdb].[dbo].[sp_add_jobserver], [msdb].[dbo].[sp_sqlagent_has_server_access], [msdb].[dbo].[syscachedcredentials]
msdb.dbo.sysoriginatingservers_view View msdb.dbo.sysoriginatingservers Table 3 [msdb].[dbo].[sp_add_job], [msdb].[dbo].[sysoriginatingservers_view], [msdb].[dbo].[sysoriginatingservers]
msdb.dbo.sp_update_alert Stored procedure msdb.dbo.sp_is_sqlagent_starting Stored procedure 4 [msdb].[dbo].[sp_delete_job], [msdb].[dbo].[sp_delete_job_references], [msdb].[dbo].[sp_update_alert], [msdb].[dbo].[sp_is_sqlagent_starting]

System Stored Procedure: master.dbo.sp_TSQLJobCreate

USE master
GO
IF OBJECT_ID('sp_TSQLJobCreate') IS NULL EXEC ('CREATE PROCEDURE sp_TSQLJobCreate AS SELECT 1 AS ID')
GO
ALTER PROCEDURE dbo.sp_TSQLJobCreate
    @job_name NVARCHAR(256),
    @step_name NVARCHAR(256),
    @database_name SYSNAME,
    @TSQLCommand NVARCHAR(MAX),
    @Overwrite BIT = 1,
    @notify_email_operator_name NVARCHAR(256) = NULL,
    @owner_login_name NVARCHAR(256) = NULL
AS
SET NOCOUNT ON
SET TRANSACTION ISOLATION LEVEL READ UNCOMMITTED

IF @owner_login_name IS NULL
    BEGIN
        DECLARE @ServicePath NVARCHAR(156) = N'SYSTEM\CurrentControlSet\Services\' + CASE WHEN @@SERVICENAME = 'MSSQLSERVER' THEN 'MSSQLSERVER'
                                                                                          ELSE 'MSSQL$' + @@SERVICENAME
                                                                                     END
        EXECUTE master.dbo.xp_instance_regread
            N'HKEY_LOCAL_MACHINE',
            @ServicePath,
            N'ObjectName',
            @owner_login_name OUTPUT,
            N'no_output'
    END

DECLARE @jobId BINARY(16)
IF @Overwrite = 1
    BEGIN
        SELECT  @jobId = job_id
        FROM    msdb.dbo.sysjobs (NOLOCK)
        WHERE   name = @job_name
        IF @@ROWCOUNT = 1
            EXEC msdb.dbo.sp_delete_job
                @job_id = @jobId
        SET @jobId = NULL
    END
EXEC msdb.dbo.sp_add_job
    @job_name = @job_name,
    @enabled = 1,
    @notify_level_eventlog = 0,
    @notify_level_email = 2,
    @notify_level_netsend = 2,
    @notify_level_page = 2,
    @delete_level = 0,
    @category_name = N'[Uncategorized (Local)]',
    @owner_login_name = @owner_login_name,
    @notify_email_operator_name = @notify_email_operator_name,
    @job_id = @jobId OUTPUT

EXEC msdb.dbo.sp_add_jobserver
    @job_id = @jobId,
    @server_name = @@SERVERNAME

EXEC msdb.dbo.sp_add_jobstep
    @job_name = @job_name,
    @step_name = @step_name,
    @step_id = 1,
    @cmdexec_success_code = 0,
    @on_success_action = 1,
    @on_fail_action = 2,
    @retry_attempts = 0,
    @retry_interval = 0,
    @os_run_priority = 0,
    @subsystem = N'TSQL',
    @command = @TSQLCommand,
    @database_name = @database_name,
    @flags = 4
IF @notify_email_operator_name <> ''
    EXEC msdb.dbo.sp_update_job
        @job_name = @job_name,
        @enabled = 1,
        @start_step_id = 1,
        @notify_level_eventlog = 0,
        @notify_level_email = 2,
        @notify_level_netsend = 2,
        @notify_level_page = 2,
        @delete_level = 0,
        @description = N'',
        @category_name = N'[Uncategorized (Local)]',
        @owner_login_name = @owner_login_name,
        @notify_email_operator_name = @notify_email_operator_name,
        @notify_netsend_operator_name = N'',
        @notify_page_operator_name = N''
GO
EXEC sys.sp_ms_marksystemobject sp_TSQLJobCreate
GO

Description for System Stored Procedure: master.dbo.sp_TSQLJobCreate

Todo
Site Map | Printable View | © 2008 - 2012 NuRoN Consulting, INC | Powered by mojoPortal | HTML 5 | CSS | Original design by Andreas Viklund
Share This Using Popular Bookmarking Services