Guest User

Untitled

a guest
Oct 20th, 2017
72
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.37 KB | None | 0 0
  1. USE [msdb]
  2. GO
  3. DECLARE @jobId BINARY(16)
  4. EXEC msdb.dbo.sp_add_job @job_name=N'XXXXXXXXXXXXXXXXXX',
  5. @enabled=1,
  6. @notify_level_eventlog=0,
  7. @notify_level_email=2,
  8. @notify_level_page=2,
  9. @delete_level=0,
  10. @category_name=N'[Uncategorized (Local)]',
  11. @owner_login_name=N'sa', @job_id = @jobId OUTPUT
  12. select @jobId
  13. GO
  14. EXEC msdb.dbo.sp_add_jobserver @job_name=N'XXXXXXXXXXXXXXXXXX', @server_name = N'DEVSQL1'
  15. GO
  16. USE [msdb]
  17. GO
  18. EXEC msdb.dbo.sp_add_jobstep @job_name=N'XXXXXXXXXXXXXXXXXX',
  19. @step_name=N'Hello, World',
  20. @step_id=1,
  21. @cmdexec_success_code=0,
  22. @on_success_action=1,
  23. @on_fail_action=2,
  24. @retry_attempts=0,
  25. @retry_interval=0,
  26. @os_run_priority=0, @subsystem=N'TSQL',
  27. @command=N'print ''Hello, World''',
  28. @database_name=N'master',
  29. @flags=0
  30. GO
  31. USE [msdb]
  32. GO
  33. EXEC msdb.dbo.sp_update_job @job_name=N'XXXXXXXXXXXXXXXXXX',
  34. @enabled=1,
  35. @start_step_id=1,
  36. @notify_level_eventlog=0,
  37. @notify_level_email=2,
  38. @notify_level_page=2,
  39. @delete_level=0,
  40. @description=N'',
  41. @category_name=N'[Uncategorized (Local)]',
  42. @owner_login_name=N'sa',
  43. @notify_email_operator_name=N'',
  44. @notify_page_operator_name=N''
  45. GO
  46.  
  47. EXEC EXEC msdb.dbo.sp_start_job @job_name = 'XXXXXXXXXXXXXXXXXX'
  48. GO
Add Comment
Please, Sign In to add comment