One more question.

Is this a valid statement?

WAITFOR DELAY '00:10:00' TIME '23:00:00'

What I need is to keep trying to find data

till 11PM. So my code looks like this:

declare @CurrentDt smalldatetime

declare @CurrentDtStr...

Great!

It works.

Thank you very much!

As soon as I got "1" when this query ran

Email started working:

SELECT TOP (1) pp.profile_id

FROM msdb.dbo.sysmail_principalprofile as pp

...

Don't have time to troubleshoot XML format problem.

I just changed it back to:

and...

Slowly but problems are being solved..

I created Niad.dtsConfig file:

( Sorry. When this post gets saved XML code dissapears.

How to post code properly?

I use IFCode icon in the "Edit...

I changed SSIS Properties.

Security/Protection Level

set to "DontSaveSensitive"

Now "DTS: Password" error is gone but I still get the errors

when running as "xp_cmdshell 'dtextec.....' " from QA

and actually it's the same...

The problem is solved.

This works.

declare @str1 varchar(100)

set @str1 = '"C:\Program Files\Microsoft SQL Server\90\DTS\Binn\DTexec.exe"'

set @str1 = @str1 + ' /f e:\ssis_packages\Niad.dtsx'

EXECUTE master.dbo.xp_cmdshell @str1

SSIS package is being executed now.

But the journey is...

I am moving this topic to SSIS Forum...

Article doesn't help.

I have new details now.

I actually logged to the target server

and ran this command:

It recognizes the utility. The output is:

Microsoft (R) SQL...

What is DB2 box is not part of the domain?

I think it's not. It's sitting on Linux box.

Sorry. I'm not following you Mark.

For DB2 linked server we use "app" account with limited rights.

I'm not sure but I think it has only READ permissions.

This account works. We tested it a lot of times...

Here is the solution.

I created a SQL Server account on ServerA

as SYSADMIN. I connect to ServerA in QA using this account.

Now all my distributed queries to DB2 linked server (ServerB)...

Thanks. I figured it out.

Is there a T-SQL code to do the same thing?

If you right-click the job in EM

you have:

New Job

Start Job

Stop Job

Enable Job

View Job History...

Refresh Job

All Tasks >Generate SQl script

Delete

Properties

Help

Where should I go to execute a specific Job Step?