Viewing 15 posts - 8,086 through 8,100 (of 9,707 total)
And apparently we never caught the "all connections on the server" part of the OP.
DOH!
March 29, 2010 at 8:49 am
shanila_minnu (3/29/2010)
wat is the difference between date_modified and run_time.when i executed like belowSELECTb.run_time,b.run_date,a.date_modified,*
FROM
MSDB.dbo.sysjobs a inner join MSDB.dbo.sysjobhistory b
on a.job_id=b.job_id
where a.date_modified > '2006-08-17 12:22:14.440'
it is showing both run_date,date_modified almost simillar
The date_modified...
March 29, 2010 at 8:08 am
One potential problem I see right off the bat. You're dropping the job off it's modified date instead of it's last run date, which is what you originally wanted. If...
March 29, 2010 at 7:28 am
Why not just do a restore-from-backup to the reporting instance and create the indexed views as part of the job that auto-restores for you?
EDIT: Then add specific perms for the...
March 29, 2010 at 6:10 am
No, I don't have a query. I've never needed to write one.
It's not that hard, though. Look up the code in Books Online. It's the best way for you to...
March 29, 2010 at 6:07 am
If this has happened to you recently and you're running Windows 2003 SP 2, you need to check out the following links:
March 29, 2010 at 6:03 am
There is no other approach. You can add multiple schedules to a job, but you can't have those schedules run different steps of the job. It's all or nothing.
If you...
March 29, 2010 at 5:51 am
Are you doing this from a DVD or a .msi file provided by your corporate IT office?
March 29, 2010 at 5:49 am
Use a WHILE loop or a CURSOR on the sp_delete_job command.
The table sysjobhistory contains the columns run_date and run_time. You can use those columns to determine the last time the...
March 29, 2010 at 5:48 am
Do the dreaded cursor, and use dynamic sql to throw in the spids, on the "Kill" command.
It's usually efficient and effective, but if any threads are rolling back, nothing...
March 29, 2010 at 5:42 am
John Rowan (3/23/2010)
I was born just outside of Rapid City, at Elsworth AFB, but have lived in Omaha most of my life.
Really? Funny how small the world is. I spent...
March 29, 2010 at 5:37 am
PhilPacha (2/22/2010)
Springfield, Illinois, U.S.A.
Hey, my dad used to work in that town!
Not very elaborate for a state capital, is it? @=)
March 29, 2010 at 5:32 am
The armpit of Florida, Jacksonville.
And, in the spirit of the misconceptions part of this thread:
When my family moved out to Nebraska though (many years ago), some of my fellow...
March 29, 2010 at 5:22 am
Glad I could help.
March 23, 2010 at 6:32 am
Viewing 15 posts - 8,086 through 8,100 (of 9,707 total)