Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- USE [msdb]
- GO
- DECLARE @jobId BINARY(16)
- EXEC msdb.dbo.sp_add_job @job_name=N'XXXXXXXXXXXXXXXXXX',
- @enabled=1,
- @notify_level_eventlog=0,
- @notify_level_email=2,
- @notify_level_page=2,
- @delete_level=0,
- @category_name=N'[Uncategorized (Local)]',
- @owner_login_name=N'sa', @job_id = @jobId OUTPUT
- select @jobId
- GO
- EXEC msdb.dbo.sp_add_jobserver @job_name=N'XXXXXXXXXXXXXXXXXX', @server_name = N'DEVSQL1'
- GO
- USE [msdb]
- GO
- EXEC msdb.dbo.sp_add_jobstep @job_name=N'XXXXXXXXXXXXXXXXXX',
- @step_name=N'Hello, World',
- @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=N'print ''Hello, World''',
- @database_name=N'master',
- @flags=0
- GO
- USE [msdb]
- GO
- EXEC msdb.dbo.sp_update_job @job_name=N'XXXXXXXXXXXXXXXXXX',
- @enabled=1,
- @start_step_id=1,
- @notify_level_eventlog=0,
- @notify_level_email=2,
- @notify_level_page=2,
- @delete_level=0,
- @description=N'',
- @category_name=N'[Uncategorized (Local)]',
- @owner_login_name=N'sa',
- @notify_email_operator_name=N'',
- @notify_page_operator_name=N''
- GO
- EXEC EXEC msdb.dbo.sp_start_job @job_name = 'XXXXXXXXXXXXXXXXXX'
- GO
Add Comment
Please, Sign In to add comment