Viewing 15 posts - 46 through 60 (of 149 total)
The Agent job Owner has sa server role membership.
You wanna hear something crazy? We changed just the time this SQL Agent job executes to 10 minutes from now (well 15...
January 27, 2011 at 4:16 pm
Is it safe to assume that when you say take a backup of the TX log, you mean using the SQL native backup and not RedGate?
We'll try that and let...
January 7, 2011 at 11:31 am
We will try that.
I'll let you know if it worked.
Thanks
January 7, 2011 at 11:30 am
Make sure the domain account the SQL Service runs under is the same on both servers. If they are not, then make them.
Also, you may need to setup a SPN...
January 6, 2011 at 8:38 pm
So your saying that "If the second subreport is not embedded in a tablix" it shouldn't re-query SQL for the same recordset and the subreport will use the first reports...
October 14, 2010 at 12:03 pm
The linked server works properly. I am able to query tables with no probs.
I can also execute a stored proc that exists on the linked server like so....
EXEC [HOUSEOFPAIN].BRUISE..sp_SmackDaFoo...
August 25, 2010 at 10:47 am
OK, I figured it out. In the backup maintenance package that I created in BIDS for backup, you create a SQL agent job. Within the SSIS package that got built...
August 25, 2010 at 9:38 am
Make sure the switch you are attached to is set to the same Duplex level as your NIC. If your switch is set to 1000Mb/s FULL DUPLEX and your server...
August 24, 2010 at 9:51 pm
It took ~2.5hrs. That's normal. Typically it's 2.5-3hrs depending on what's running.
There really is no different executing an SSIS pkg as a job compared to a step withing several...
August 2, 2010 at 12:02 pm
OK, I opened just that step in BID's, no issues. I even exported it to a file then ran it, it finished OK. The standalone SQL Agent job runs fine....
August 1, 2010 at 10:16 pm
If it means anything, when I run the original SQL Agent Job (which is a step in the job I am having issues with), it runs with no problems.
I'll try...
August 1, 2010 at 12:27 pm
Here's the log output of the one step in the job...
Microsoft (R) SQL Server Execute Package Utility
Version 9.00.4035.00 for 32-bit
Copyright (C) Microsoft Corp 1984-2005. All rights reserved.
Started: 11:08:13 PM
DTExec:...
July 31, 2010 at 5:40 pm
Here's the log from SSIS starting one of the steps...
Date 7/30/2010 11:09:05 PM
Log Windows NT (NT Events)
Source SQLISPackage
Category (0)
Event 1073819648
User MPAPSDB\localsqlservices
Computer MPAPSDB
Message
Package "Daily ReBuild Indexes" started.
Here's the log that says it finished the step...
Date 7/30/2010 11:09:05 PM
Log Windows NT...
July 31, 2010 at 12:54 pm
Here's a quick example of what I did.
I already had each job as their own SQL agent job. Some were SSIS packages and some were T-SQL execution.
So what I...
July 30, 2010 at 5:39 pm
blackbird (7/30/2010)
Just out of curiosity, what happens when you run the job manually?
I think i'll try a manual start tonight after it finishes tonight. I already know it won't actuallrun...
July 30, 2010 at 5:04 pm
Viewing 15 posts - 46 through 60 (of 149 total)