Simon D Richards (3/13/2013)

---

I know this is old, but I had a similar issue recently. It was a security issue. For whatever reason, the security was not propagated properly during...

AS400 DB2. I have an AS400 login so that is not the issue.

I tried that a few times...

No File System Operations.

It pulls Data from Oracle and loads into into aSQL Server Staging area.

It is not just one package but all ETL packages that I have tested.

If you want to identify the SPID on the remote Server you need to connect to the Remote Server.

I often use sp_who3 and sp_WhoIsActive. They will only show active...

I opened a new thread:

http://www.sqlservercentral.com/Forums/Forum1550-1.aspx?Update=1

It is stored in MSDB, thanks.

I will open a new thread.

I get this error when I attempt to run the Package using the Domain Account, SQLServerAgent.

Message

Executed as user: MyDomain\SQLServerAgent. Microsoft (R) SQL Server Execute Package Utility Version 10.50.2500.0 for 64-bit...

Thanks.

The folder was hidden granted permissions and I still get the error.

I can't find this folder.

What is the entore path?

Thanks!

I have the following code:

SELECT DISTINCT j.name as job_name, run_duration,

msdb.dbo.agent_datetime(run_date, run_time) AS [run_datetime],

DATEADD(second,DATEDIFF(second,0,msdb.dbo.agent_datetime(19000101, run_duration)),msdb.dbo.agent_datetime(run_date, run_time)) AS [run_endtime]

,SUBSTRING(run_duration, 1, 2) + ':' + SUBSTRING(run_duration, 3, 2) + ':' +

...

SQLRNNR (3/11/2013)

---

Jeff Moden (3/11/2013)

---

David Burrows (3/11/2013)

---

SELECT DISTINCT j.name as job_name,

msdb.dbo.agent_datetime(run_date, run_time) AS [run_datetime],

DATEADD(second,DATEDIFF(second,0,msdb.dbo.agent_datetime(19000101, run_duration)),msdb.dbo.agent_datetime(run_date, run_time)) AS [run_endtime]

FROM msdb..sysjobhistory h

INNER JOIN msdb..sysjobs j ON h.job_id = j.job_id

WHERE j.name NOT LIKE...

Lynn Pettis (3/10/2013)

---

Since some of us do not necessarily have a similar environment as you, it may be helpful if you created temporary tables and populated it with data from...

Aspet Golestanian Namagerdi (3/4/2013)

---

In sysmail_sentitems,there is not any record.

In sysmail_unsentitems,In includes all the test emails I have tried

In sysmail_event_log does not show that DatabaseMail process has been started to...

Did you try running opc.three's Scripts?