× Heads up!

Aqua Data Studio / nhilam

Follow
IDE for Relational Databases
×
narendravatsaraj(*) reported 2014-12-17T12:20:40Z  · tariqrahiman last modified 2014-12-17T23:34:28Z

SQLServer 2014 - SQL Server Agent - Jobs Properties -> "Notification" tab all options are not disabled.


Dev
Jenny Nishimura
JennyNishimura
QA
Tariq Rahiman
tariqrahiman
Priority Low
Complexity Unknown
Component App - Visual Editing
Version 16.0

 

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.

 

1 attachment
  • Job.png

    2014-12-17T12:27:03Z

    383 KB

Issue #12985

Closed
Fixed
Resolved 2014-12-17T23:08:07Z
 
 
Completion
No due date
Fixed Build ADS 16.0.0-dev-78
No time estimate

About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017