Home Dashboard Directory Help
Search

SQL 2012 SP1 (CU3) Job Values Issue by Chenn Ronen - SolidBI


Status: 

Closed


4
0
Sign in
to vote
Type: Bug
ID: 785208
Opened: 4/21/2013 1:51:31 AM
Access Restriction: Public
0
Workaround(s)
view
0
User(s) can reproduce this bug

Description

Disappearing Values in Set Values tab of SQL Agent Job:

When migrating SSIS from Sql 2008R2 to Sql 2012Sp1 Cu3.

We found some issues with SQL server Agent:
Job steps don't keep configuration of set value, when changed.
After different tests we figured out that SQL Server management studio writes job steps details into MSDB database sysjobsteps table by using different format then SQL server 2008. This problem can be reproduced by the following test: When the value inserted includes "" – all information desapear. Without "" – works correctly.

You can see the difference by running the follow query on the server msdb:

select command, * from [dbo].[sysjobsteps] where step_uid = 'F49B3F01-19C2-4215-98FE-8B832DD2FD88'
select command as From_2008,* from query_Job where step_uid = '9788474D-380A-4CF6-BEEA-71CFEF8F8DFF'


This are the results from
select command, * from [dbo].[sysjobsteps] where step_uid = 'F49B3F01-19C2-4215-98FE-8B832DD2FD88'

/DTS "\"\MGR\MGR_QG\Pkg_Qg_Execute_Folder\"" /SERVER "\"Server2012\"" /CHECKPOINTING OFF /SET "\"\Package.Variables[User::Folder_Id]\"";"\"\"\"44017\"\"\"" /REPORTING E


This is the results from
select command as From_2008,* from query_Job where step_uid = '9788474D-380A-4CF6-BEEA-71CFEF8F8DFF'

/DTS "\MGR\MGR_QG\CurrentVersion\Pkg_Qg_Execute_Folder" /SERVER "Server2008R2" /CHECKPOINTING OFF /SET "\Package.Variables[User::Folder_Id]";"""103633""" /REPORTING E
Details
Sign in to post a comment.
Posted by Chenn Ronen - SolidBI on 6/17/2013 at 9:54 PM
Thanks Guys.
Posted by Microsoft on 6/17/2013 at 2:38 PM
Hello Chenn. Thanks for bringing this to our attention. This has been fixed. The change will be included in a future release or servicing release for SQL Server.

-Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Microsoft on 4/26/2013 at 9:53 AM
Hello Chenn. Thank you for bringing this to our attention. We really do appreciate the feedback. We’ll investigate and get back to you. -Walter A Jokiel, Program Manager, SQL Server (wajokiel@microsoft.com)
Posted by Chenn Ronen - SolidBI on 4/21/2013 at 8:01 AM
same bug was on SQL 2005:

https://connect.microsoft.com/SQLServer/feedback/details/294599/disappearing-values-in-set-values-tab-of-sql-agent-job-maintenance#details
Sign in to post a workaround.