No announcements
Found 1596390 threads
-
0 VotesSQL 2005 job is failing
SQL Server 2005 version: 2153 I created a maintplan for system and user databases includes rebuild index, maint cleanup tasks.Answered | 1 Replies | 6529 Views | Created by kidstuff - Wednesday, December 5, 2007 2:33 AM | Last reply by Madhu K Nair - Wednesday, December 5, 2007 3:49 AM
-
2 Votes
SQL Job Agent not working?
Hi, Problem Resolved .i was unable to find SQL job Object Discovery whcih i later did find and then Enabled it and got the SQL job ...Answered | 4 Replies | 4518 Views | Created by SA-CDC - Thursday, September 8, 2011 11:26 AM | Last reply by SA-CDC - Thursday, October 6, 2011 10:26 AM -
0 Votes
Migrating Jobs: SQL 2005 32bit > SQL 2005 64bit
There is a blog post Scripting all jobs on SQL Server 2005/2008 into one file showing how to script all jobs at once.Answered | 2 Replies | 4502 Views | Created by Mdub03 - Thursday, November 4, 2010 12:55 PM | Last reply by Naomi N - Thursday, November 4, 2010 1:54 PM -
1 Votes
Detection of SQL Agent job execution.
This is supported, with each backup appending to the file.Answered | 3 Replies | 2354 Views | Created by Andy Mishechkin - Friday, September 28, 2012 10:00 AM | Last reply by SQLWork - Saturday, September 29, 2012 8:55 PM -
0 Votes
Sql 2005 Scheduled Job not firing
Setting: sql 2005, SP1.Answered | 1 Replies | 6434 Views | Created by edm2 - Friday, February 9, 2007 7:22 PM | Last reply by Buck Woody - MSFT - Tuesday, February 13, 2007 4:24 PM -
0 Votes
Stoping CDC cleanup job IN CDC
As already suggested it propably slow down the process but incase you want to ...Answered | 3 Replies | 2300 Views | Created by vikas kumar pathak - Monday, November 18, 2013 7:11 AM | Last reply by Neha Mahajan DBA - Monday, November 18, 2013 9:47 AM -
0 Votes
SQL Jobs history in Sql 2005
to that comment out the below code : WHERE JOB.job_id= 1000 Specify the ID no. in where clause .Answered | 4 Replies | 1353 Views | Created by VijayKSQL - Tuesday, January 15, 2013 9:39 AM | Last reply by Ahsan Kabir - Wednesday, January 16, 2013 6:47 PM -
0 Votes
SQL JOB History & JOB Activity
I would suggest you to have a look at ...Answered | 2 Replies | 4670 Views | Created by Sudhir.Nune - Monday, June 25, 2012 1:04 PM | Last reply by Papy Normand - Friday, June 29, 2012 3:49 PM -
0 Votes
Unable to change Job owner of the SQL Agent Job
If you capture the code executed when you change job owner on a working instance by using profiler, you could then execute these steps in a query window for the misbehaving instance, ...Answered | 10 Replies | 11891 Views | Created by NileshPatil - Wednesday, July 28, 2010 10:13 AM | Last reply by Davies, Paul - Tuesday, March 20, 2018 2:15 PM -
0 Votes
SSIS - sql job fails
thank you it worksAnswered | 2 Replies | 1335 Views | Created by Mr Mohamed Ismail - Thursday, April 18, 2013 2:42 PM | Last reply by Mr Mohamed Ismail - Sunday, April 21, 2013 8:45 AM -
0 Votes
Timer Job not working correctly
You must call item.Update() method in your most inner for each loop.Answered | 3 Replies | 6578 Views | Created by Shekhar R - Friday, March 4, 2011 8:47 AM | Last reply by Moonis Tahir - Friday, March 4, 2011 3:33 PM -
0 Votes
SQL Job Steps Not Visable
I have a developer that is running SSMS on his laptop and is not able to view any Steps within SQL Jobs, even his own Jobs.Answered | 3 Replies | 7062 Views | Created by sqlmikesql - Friday, April 29, 2011 6:51 PM | Last reply by Abhay_78 - Saturday, April 30, 2011 6:28 AM -
1 Votes
Sql Job
you can write "EXEC your_spname" in your job step...Answered | 7 Replies | 5346 Views | Created by AlBar0726 - Monday, May 30, 2011 4:28 PM | Last reply by FarhanAhmed-Xerva - Monday, May 30, 2011 7:41 PM -
0 Votes
SQL Agent job modification
About your screenshot, we found that all options of T-SQL scripts are gray in job step properties Advanced page.Answered | 5 Replies | 1532 Views | Created by sakurai_db - Friday, June 20, 2014 4:43 AM | Last reply by Sofiya Li - Monday, June 23, 2014 2:43 AM -
11 Votes
Adding a job to sql agent
I am able to create the jobs by hand, ie I execute sp_add_job manually for each job needing to be created.Answered | 25 Replies | 15173 Views | Created by wpfeffer - Friday, October 16, 2009 12:43 AM | Last reply by WeSam Abdallah - Tuesday, September 4, 2012 7:44 PM -
0 Votes
Launching pkg in a scheduled job working SQL Server 2005 Standard Edition
It is completely possible to set up and execute a job in SQL 2005 Standard Edition that runs SSIS packages.Answered | 1 Replies | 4027 Views | Created by pscorca - Saturday, November 28, 2009 9:07 AM | Last reply by Todd McDermid - Saturday, November 28, 2009 4:29 PM -
0 Votes
SQL Agent Job Monitoring
It is also not a behavior of the SQL management pack which does provide a single threshold for job duration.Answered | 1 Replies | 3929 Views | Created by Rossbo - Monday, April 26, 2010 4:07 PM | Last reply by Dan Rogers - Tuesday, April 27, 2010 5:04 AM -
2 Votes
SQL Agent Job - Who modified job
Sorry, but SQL Server doesn't store this information, so you are out of luck.Answered | 2 Replies | 7863 Views | Created by Jeelani Kamal - Thursday, May 19, 2011 2:35 PM | Last reply by John Sansom - Thursday, May 19, 2011 4:04 PM -
0 Votes
job
Do you mean you changed the account for Sql Agent Service?Answered | 4 Replies | 6479 Views | Created by arkiboys - Tuesday, January 5, 2010 2:30 PM | Last reply by tibid - Wednesday, January 6, 2010 8:21 PM -
0 Votes
SQL Server Job
The 2 hour time wait adds a little trickery in there, but I think you could do that with a sql task in a for each loop like mentioned ...Answered | 2 Replies | 2515 Views | Created by Lala P - Thursday, January 5, 2012 11:10 PM | Last reply by Anthony Mattas - Friday, January 6, 2012 5:34 AM - Items 1 to 20 of 1596390 Next ›
No announcements
