Viewing 15 posts - 3,076 through 3,090 (of 9,707 total)
Shawn Melton (9/17/2014)
What query are your trying to execute to get job status?
[linkedserver].master.dbo.xp_sqlagent_enum_jobs
September 17, 2014 at 9:57 am
This sounds like a job for SSIS!
@=)
September 17, 2014 at 9:43 am
Did you check the Event Viewer or just the SQL logs?
September 17, 2014 at 9:41 am
What Greg said, combined with what ZZartin said.
If you want your job to use an Integration Services step to run the package, you need to have IS installed and running...
September 17, 2014 at 9:40 am
Andrei-176105 (9/17/2014)
I have a bunch of servers (2000, 2005,2008,2012) that run bakups to network filer.
All servers (and SQL Agents) run under the same domain account.
This account has full permissions to...
September 17, 2014 at 9:36 am
Steve Jones - SSC Editor (9/10/2014)
Admin stuff fairly similar in most cases. Lots of T-SQL changes. The Inside SQL Server stuff, especially Itzik's Windowing book are great.
Thanks, Steve. I'll look...
September 10, 2014 at 9:49 am
thomashohner (9/10/2014)
I thought the 2008 cert was expired anyway?
After I posted here, I read an article on MSSQL Tips that said no more 2008 certs would be handed out after...
September 10, 2014 at 9:49 am
Wunderbar! I'll take a look.
Thank you.
September 10, 2014 at 5:37 am
It's always better to certify on the latest rather than the one that is about to become obsolete, unless you plan on only working for people who use SQL 2008....
September 10, 2014 at 4:29 am
Shiva N (9/8/2014)
hi please provide me the Training kit on xxxx@xxx.xxxx
Go to Microsoft's website for training kit information. You can order one through there.
By the way, it is a REALLY...
September 9, 2014 at 4:15 am
satish.saidapur (8/22/2014)
HiI have faced same issue after updating SP.
When the Database take offline and back to online its work fine...
That is...
August 25, 2014 at 7:16 am
SQLisAwE5OmE (8/23/2014)
Hi Brandie,"I've created a job to initiate failover of the mirrors in case of database failure"
Do you mind sharing how you setup the job?
The job I set up is...
August 25, 2014 at 6:52 am
Myke85, your code still has the same problem that Tom pointed out. Are you sure that's the code you want to stick with?
August 25, 2014 at 5:56 am
That is a good point, Tom. And not something even my Theatre of the Absurd code addresses.
August 22, 2014 at 11:07 am
Viewing 15 posts - 3,076 through 3,090 (of 9,707 total)