I assigned the user permission to start job .

How does he know when it completes ?

ALTER PROC usp_StartTransformationJob

@MyJobName sysname = 'Transformation'

AS

DECLARE @ReturnCode tinyint -- 0 (success) or 1...

Can you provide me with a sample procedure or some helpful links ?

I am using Enterprise edition and going to run subscription from SharePoint.

Microsoft SQL Server 2012 (SP1) - 11.0.3000.0 (X64)

Oct 19 2012 13:38:57

Copyright (c) Microsoft Corporation

Enterprise Edition (64-bit) on...

Server is UTC time zone .

I just need to delete today's records and insert new ones and keep yesterday and older records. Rest (time zone) is not mandatory.

I want the CST time recorded . If I don't do a -5 then May3rd, 7pm would be inserted as May 4th,00 am .

I have to run this code once every hour .

SELECT JS.PackageName,JS.ProjectName,JS.StartTime,JS.EndTime,CASE WHEN JS.StatusDescription is NULL THEN ' Not-Executed' ELSE JS.StatusDescription END AS StatusDescription

FROM #DateHr DHr LEFT JOIN #JobStatus JS ON DHr.Hour = JS.Hour AND Dhr.StartTime =...

Thanks!

When it comes to performance , it's very poor. Can we improve performance for this query.

Thanks!

Need the unmatched as well .

SELECT 'ABCvvv' AS Text ,'No'

Thanks!. That was it .

Alerts :When an SSIS package that is executed as SQL Job fail , users are receiving an alert from test@xyz.com

How can I investigate that ? When I look at...

The user is an AD user and not a sql user .

Thank you. Worked perfectly.