No announcements
Found 3837672 threads
-
0 Votes
under sql server job agent, view job history gets time out error message.
see http://www.jamesserra.com/archive/2011/06/easier-way-to-view-sql-server-job-history/ Please Mark This As Answer if it helps ...Answered | 2 Replies | 1403 Views | Created by bestrongself - Sunday, March 9, 2014 5:18 PM | Last reply by Visakh16 - Sunday, March 9, 2014 5:54 PM -
0 Votes
Complete error message for jobs in Sql Server Agent
http://www.mssqltips.com/sqlservertip/1394/how-to-store-longer-sql-agent-job-step-output-messages/ http://www.mssqltips.com/sqlservertip ...Answered | 2 Replies | 1510 Views | Created by SSDL - Monday, March 17, 2014 5:09 AM | Last reply by Visakh16 - Monday, March 17, 2014 6:32 AM -
0 Votes
SQL Server Agent Job History?
Hi Mira, SQL Server does not keep Job definition change history until unless you have implemented your own such solution to track changes.Answered | 4 Replies | 900 Views | Created by Mira Pimbi - Wednesday, January 11, 2017 2:47 AM | Last reply by Sunil Gure - Wednesday, January 11, 2017 5:06 AM -
0 Votes
sql server agent jobs history
\Program Files\Microsoft SQL Server\MSSQL10_50.Instance\MSSQL\Log.Answered | 7 Replies | 3234 Views | Created by subu999 - Tuesday, October 2, 2012 9:12 AM | Last reply by subu999 - Wednesday, October 3, 2012 9:36 AM -
0 Votes
How to Get SQL Server Agent JOBS Details
Hi All, In SQL Server Agent (2012 Version )There are many(100) JOBS created.Answered | 3 Replies | 880 Views | Created by balakrishna141 - Thursday, September 10, 2015 6:38 AM | Last reply by Shanky_621 - Thursday, September 10, 2015 6:56 AM -
0 Votes
SQL Server Agent for spacific job
Hi, If a job runs manually, but not through Agent, it is almost always a permissions issue with the SQL Agent Service account (Which is the ...Answered | 1 Replies | 6355 Views | Created by Abdvip1 - Saturday, March 24, 2012 12:49 PM | Last reply by Pete A Carter - Author Pro SQL Server Administrati - Sunday, March 25, 2012 11:35 AM -
6 Votes
Cannot drop job under SQL Server Agent
And I am unable to delete the jobs showing up in the agent or using sql to delete the row in sysjobs table due to the same error message seen in this ...Answered | 9 Replies | 19931 Views | Created by JulieShop - Wednesday, July 25, 2007 12:56 AM | Last reply by mbeckwith - Wednesday, March 29, 2017 5:56 PM -
0 Votes
SQL Server Agent Job
Right, if you have SQL Server Express, you can't create a job through SQL Server.Answered | 5 Replies | 1956 Views | Created by GTanna - Wednesday, March 25, 2015 2:47 PM | Last reply by ryguy72 - Friday, April 3, 2015 6:26 PM -
0 Votes
SQL JOB History & JOB Activity
I would suggest you to have a look at ...Answered | 2 Replies | 4601 Views | Created by Sudhir.Nune - Monday, June 25, 2012 1:04 PM | Last reply by Papy Normand - Friday, June 29, 2012 3:49 PM -
4 Votes
SQL agent job history retention can not be set
You can't limit it for a time period like 60 days, only for the amount of rows for a job / in total.Answered | 5 Replies | 4164 Views | Created by Human Being_001 - Tuesday, August 13, 2013 12:30 AM | Last reply by Human Being_001 - Tuesday, August 13, 2013 5:40 AM -
0 Votes
Getting error in SQL Agent JOb
In your package job step, what is your package running under?Answered | 11 Replies | 755 Views | Created by MustafaH - Tuesday, May 9, 2017 11:03 AM | Last reply by Pirlo Zhang - Wednesday, May 10, 2017 6:58 AM -
3 Votes
SQL Server Agent job running with no schedule
Hi, if you dont want that Scheduled job to be executed again again so disable it from SQL agent jobs tab and then also it is still executing ...Answered | 2 Replies | 6428 Views | Created by Millstone1998 - Wednesday, August 29, 2012 8:23 AM | Last reply by Ashish_DbaSQL - Thursday, August 30, 2012 7:49 AM -
4 Votes
access to view job history only
Go through below link ...Answered | 4 Replies | 5951 Views | Created by csharp4Programmer - Wednesday, September 18, 2013 4:21 PM | Last reply by csharp4Programmer - Thursday, September 19, 2013 1:52 PM -
0 Votes
SQL SERVER AGENT JOBS FAILED
Hi coool_sweet, Based on my research, the issue always occurs when the SQL Server Agent Service not start, it might be in Starting mode.Answered | 4 Replies | 2538 Views | Created by coool_sweet - Tuesday, June 16, 2015 11:45 AM | Last reply by Katherine Xiong - Friday, June 19, 2015 3:14 AM -
1 Votes
SQL Agent jobs hanging
I am having this problem with our sql server 2005 sp3 as well. the SQL Server Agent is running the jobs in ...Answered | 22 Replies | 49620 Views | Created by GMTI_Jerry - Wednesday, May 9, 2007 4:27 PM | Last reply by Nemesisss - Friday, March 15, 2013 5:26 PM -
0 Votes
SQL Agent Job Schedules Getting Skipped
It is pretty clear from the SQL job history, it skipped the schedule.Answered | 6 Replies | 2989 Views | Created by Samantha v - Thursday, March 24, 2016 10:22 AM | Last reply by Samantha v - Thursday, March 24, 2016 5:27 PM -
0 Votes
job history
SQL Server Agent -->select Properties --> History --> Check what is the Maximum Job History rows per Job incase consider ...Answered | 2 Replies | 2274 Views | Created by DBA_LEARNER - Wednesday, October 17, 2012 9:40 PM | Last reply by Ramesh Babu Vavilla - Thursday, October 18, 2012 10:01 AM -
4 Votes
Job failed with error when calling SSIS package in sql agent job.
Here is the fix.Answered | 3 Replies | 32445 Views | Created by SR_MCTS - Monday, July 3, 2017 10:15 AM | Last reply by SR_MCTS - Thursday, July 6, 2017 1:43 PM -
0 Votes
sql server agent job with SSIS
"View History"), or if this is a virtual machine, check if there is an external backup that needs to shut down or pause the machine.Answered | 4 Replies | 2295 Views | Created by DataNerdE - Monday, January 27, 2014 2:20 PM | Last reply by Saurabh Sinha DBA - Tuesday, February 4, 2014 6:25 PM -
1 Votes
Sql Server Job Agent History -- Log File Viewer in SSMS
Presumably this link is 100% accurate (or is SSMS Log Viewer only correct some of the time?)Answered | 11 Replies | 1822 Views | Created by admin_veratech - Monday, September 19, 2016 2:53 AM | Last reply by TiborK - Tuesday, September 20, 2016 8:45 AM - Items 1 to 20 of 3837672 Next ›
No announcements