Aqua Data Studio 16.0.0-dev-77
1.Connect to SQL server 2014.
2.Go to Management -> SQL Server Agent - >Jobs tree node.
3.In create Job window,fill all details in General tab/step tab.
4.In "Notifiacation" tab,enable all options by checking all check boxes.
5.Click on Create"
6.Job created successfully with below sql script.
msdb..sp_add_job @job_name = N'Test_Job' , @enabled = 0 , @start_step_id = 1 , @notify_level_eventlog = 2 , @notify_level_email = 2 , @notify_level_netsend = 2 , @notify_level_page = 2 , @delete_level = 1 , @description = N'' , @category_name = N'Data Collector' , @owner_login_name = N'GANDHARI_VM\Saima' , @notify_email_operator_name = N'Narendra' , @notify_netsend_operator_name = N'Narendra' , @notify_page_operator_name = N'Narendra'
GO
EXEC msdb..sp_add_jobserver @job_name=N'Test_Job'
GO
EXEC msdb..sp_add_jobstep @job_name=N'Test_Job', @step_id=1, @step_name=N'Step1', @cmdexec_success_code=0, @on_success_action=3, @on_success_step_id=0, @on_fail_action=2, @on_fail_step_id=0, @retry_attempts=0, @retry_interval=0, @os_run_priority=0, @subsystem=N'TSQL', @command=N'', @database_name=N'a111', @server=NULL, @database_user_name=NULL, @output_file_name=NULL, @flags=0
GO
7.Now right click on created job,select option "Job Properties".
8.Go to "Notification" tab,Here you we see last two options are not disabled.
These two options("write to event log" and "Automatically delete job") should be in disabled state.
|
383 KB
To reproduce, navigate to SQL Server 2014 and go to SQL Server Agent -> Jobs and take properties of sys policy_purge_history and you can see that for properties, Notifications is not disabled.
Issue #12985 |
Closed |
Fixed |
Resolved |
Completion |
No due date |
Fixed Build ADS 16.0.0-dev-78 |
No time estimate |
To reproduce, navigate to SQL Server 2014 and go to SQL Server Agent -> Jobs and take properties of sys policy_purge_history and you can see that for properties, Notifications is not disabled.