No announcements
Found 3837564 threads
-
0 VotesSql server agent job not running
i open that server daily @ 10 am then next i schdule it for 10.30 then it loads the data Please post the job history details as requested by RSingh, and also the ...Answered | 5 Replies | 1894 Views | Created by maheshbabuk - Friday, July 19, 2013 6:47 AM | Last reply by Koen Verbeeck - Friday, July 19, 2013 9:37 AM
-
0 Votes
Job History Dissapearing - How to troubleshoot?
I will try it out, thank you.Answered | 8 Replies | 5990 Views | Created by Pedro Samuel - Wednesday, May 11, 2011 1:05 PM | Last reply by Jeff Williams 3188 - Thursday, May 12, 2011 4:01 AM -
4 Votes
critical error " SQL Agent Job info:
The error message states that the job is unable to connect to the SQL Server instance that the job targets.Answered | 6 Replies | 3822 Views | Created by Joseph varghese - Monday, May 23, 2016 6:47 AM | Last reply by Ed Price - MSFT - Tuesday, December 20, 2016 3:13 AM -
0 Votes
SQL Agent Job History Best practices
Having all the replication agents firing every 5 minutes generates an immense quantity of rows, (jobs X subscriptions).Answered | 3 Replies | 5118 Views | Created by tski113 - Wednesday, June 5, 2013 9:05 PM | Last reply by Saurabh Sinha DBA - Sunday, June 9, 2013 5:49 PM -
4 Votes
Job failed with error when calling SSIS package in sql agent job.
Here is the fix.Answered | 3 Replies | 33069 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 job history disappears
I mean, if the number of rows in my job history is 999 and then another X job logged something in that job history, everything will be ...Answered | 9 Replies | 2222 Views | Created by Butmah - Monday, May 25, 2015 10:12 AM | Last reply by Butmah - Monday, May 25, 2015 12:03 PM -
0 Votes
Permission issue ,Sql server Agent Job,SSMS
Hi All, I have fix the user permission issue but still can't run the stored proc using agent job.Answered | 4 Replies | 4561 Views | Created by ken Myer - Thursday, August 10, 2017 1:54 AM | Last reply by kccrga - Tuesday, August 15, 2017 12:33 AM -
0 Votes
SQL Job history
Remember that each execution has several rows (depending on how many job steps).Answered | 6 Replies | 1636 Views | Created by sakurai_db - Thursday, June 12, 2014 8:20 AM | Last reply by sakurai_db - Friday, June 13, 2014 3:47 AM -
2 Votes
If I resize job history log to see more entries listed under job history, will cause sql server agent to restart or any downtime?
No, the change will not restart the SQL Server Agent.Answered | 2 Replies | 1661 Views | Created by bestrongself - Monday, January 20, 2014 3:05 AM | Last reply by Neha Mahajan DBA - Monday, January 20, 2014 4:34 AM -
6 Votes
Job History Retention
If "Limit the size of job history log" is check SQL Agent history is controlled by: Maximum job ...Answered | 15 Replies | 47564 Views | Created by oleolehoohoo - Friday, November 30, 2012 7:02 PM | Last reply by Ajay.G - Thursday, June 30, 2016 10:31 PM -
0 Votes
Proper SSIS jobs error messages
Finding the actual error message inside the job history is a bit irritating.Answered | 6 Replies | 4448 Views | Created by RoniVered - Monday, August 20, 2012 10:59 AM | Last reply by DotNetMonster - Monday, August 20, 2012 3:03 PM -
2 Votes
what the maximum no of job history
Properties->History -> Modify the value 'Maximum job history log size (rows)' and 'Maximum job history rows per job' to ...Answered | 6 Replies | 7748 Views | Created by Pawan Rajput - Monday, February 28, 2011 3:39 PM | Last reply by SQLZealots - Thursday, October 31, 2013 4:45 PM -
4 Votes
sql server agent job fails,
sql server agent jobs are fails due to the "domain\login" profile is a not valid,but "domain\login" is valid login and few ...Answered | 9 Replies | 6963 Views | Created by MSDN_12345 - Friday, November 1, 2013 9:12 AM | Last reply by K Senthil - Monday, May 14, 2018 2:28 AM -
0 Votes
sql server agent job is kicked off by whom?
SQL Server Agent Job's are not event driven, they are scheduled or started manually.Answered | 4 Replies | 1347 Views | Created by bestrongself - Wednesday, May 20, 2020 9:39 PM | Last reply by Olaf Helper - Friday, May 22, 2020 8:04 AM -
0 Votes
sql server agent job
Hi Vamsivaliveti, Just as Arthur said, SQL Server Agent job and SSIS are different.Answered | 3 Replies | 2112 Views | Created by Vamsivaliveti - Thursday, October 8, 2015 6:31 PM | Last reply by Katherine Xiong - Friday, October 9, 2015 7:23 AM -
1 Votes
Job history
http://www.mssqltips.com/sqlservertip/2850/querying-sql-server-agent-job-history-data/ Please Mark This As Answer if it helps ...Answered | 1 Replies | 1224 Views | Created by bhat BK - Thursday, August 21, 2014 1:45 PM | Last reply by Visakh16 - Thursday, August 21, 2014 1:48 PM -
1 Votes
Can SQL Agent Return a More Detailed Error Message On Job Failure
Tibor Karaszi, SQL Server MVP | http://www.karaszi.com/sqlserver/default.asp | http://sqlblog.com/blogs/tibor_karasziAnswered | 5 Replies | 8801 Views | Created by Orlanzo - Friday, March 26, 2010 3:36 PM | Last reply by TiborK - Monday, March 29, 2010 4:36 PM -
2 Votes
Miantenence plan job is enabled - so why no job history in msdb.sysjobhistory?
The default configuration for SQL Server Agent History only allows for a maximum of 1000 rows total for the history or 100 rows total for a single ...Answered | 3 Replies | 1882 Views | Created by shiftbit - Friday, May 3, 2013 6:46 PM | Last reply by Jonathan Kehayias - Friday, May 3, 2013 9:24 PM -
0 Votes
locking SQL agent job
It totally depends on how the security exists in the DB server(prod/test/Dev) & how it is being managed,so this is tough challenge here.Answered | 5 Replies | 910 Views | Created by etl2016 - Thursday, August 25, 2016 1:50 PM | Last reply by S_NO - Friday, August 26, 2016 1:54 AM -
0 Votes
Are SQL jobs under SQL agent mirror-aware by default?
Andeavour, Could you provide the test process you used to verify that the SQL Agent Jobs are mirror aware when the Database is set on the job ...Answered | 6 Replies | 9205 Views | Created by jimbohhhhhhhhhhhk - Thursday, October 6, 2011 6:44 PM | Last reply by L Gamble - Thursday, December 29, 2011 6:36 PM
No announcements
