No announcements
Found 1232311 threads
-
1 VotesJob Was scheduled every 3 months
But my job was failed can you please guide me how can i work on it.Answered | 5 Replies | 5588 Views | Created by subu999 - Monday, February 1, 2010 2:14 AM | Last reply by subu999 - Monday, February 1, 2010 3:16 AM
-
0 Votes
SQL Serve Agent job time schedule to exclude 1st of every month?
= 1 begin -- sql statement end and let the schedule run everyday.Answered | 3 Replies | 5038 Views | Created by KM IT - Sunday, November 11, 2012 11:59 PM | Last reply by Marcelo Vollbrecht - Monday, November 12, 2012 12:24 AM -
0 Votes
Schedule a Report after Patch Tuesday for Every Month
Hello, When we create a subscription schedule on Report Server, a SQL Server job has been created.Answered | 7 Replies | 5976 Views | Created by SystemJay - Monday, February 11, 2013 8:33 AM | Last reply by lionking123 - Friday, March 8, 2013 4:50 AM -
1 Votes
how do I set up a schedule for a job that runs every second and third Saturday of every month
Hi, I need to run a job only on the second and third Saturday of every month.Answered | 1 Replies | 4452 Views | Created by OldManDBA - Thursday, January 5, 2012 4:48 PM | Last reply by Manish_Kaushik - Thursday, January 5, 2012 5:03 PM -
0 Votes
scheduling report on first of every month
Hi Ragavalli, As Harsh posted, you can check all of the months, select “On calendar day(s)”, and set the value to 1.Answered | 2 Replies | 1292 Views | Created by ragavalli - Monday, April 1, 2013 8:15 AM | Last reply by Mike Yin - Tuesday, April 2, 2013 7:09 AM -
4 Votes
How do I schedule a job to run everyday except the first day of every month ?
My package is scheduled to run in other jobs; if i change it to check the date, the package won't run in another job where it is scheduled the ...Answered | 7 Replies | 4303 Views | Created by wannaberelax - Tuesday, September 15, 2009 4:00 PM | Last reply by Sudeep Raj - Tuesday, September 15, 2009 5:05 PM -
0 Votes
Schedule job - recurrence between 15th and 25th day of month
If your job is a little more complex, runs SSIS or some other tool, you might need multiple steps so that the test can branch to a different job step.Answered | 2 Replies | 4730 Views | Created by michlimes - Tuesday, July 19, 2011 10:03 AM | Last reply by SQLWork - Wednesday, July 20, 2011 2:30 AM -
0 Votes
Job Schedule every 1.5hrs or 90 mins
SSMS does not allow a Job Schedule to run every 90 minutes.Answered | 6 Replies | 2155 Views | Created by Niranjan Bhat - Monday, March 24, 2014 7:28 AM | Last reply by Sofiya Li - Monday, March 31, 2014 3:26 AM -
1 Votes
Scheduling SSIS package to run on first day of every month
Thought this might help your cause...remeber to create a proxy account to run the ...Answered | 3 Replies | 4760 Views | Created by knra - Friday, December 14, 2012 3:19 AM | Last reply by Raunak J - Friday, December 14, 2012 9:33 AM -
0 Votes
List ALL SQL Job schedule
Hi Sakurai, Here is the script that will answer to get the schedule information of SQL Jobs.Answered | 8 Replies | 25822 Views | Created by sakurai_db - Tuesday, March 5, 2013 9:58 AM | Last reply by Allen Li - MSFT - Friday, March 15, 2013 1:50 AM -
0 Votes
how to schdule my job on 16th working day of the every month?
To add to Visakh's response, another method is to add the T-SQL script as the first job step to identify non-run days and raise an error when the job is not to be run.Answered | 2 Replies | 4068 Views | Created by Ychinnari - Saturday, January 4, 2014 1:01 PM | Last reply by Dan Guzman - Saturday, January 4, 2014 4:31 PM -
4 Votes
SQL agent job to run after 13 months
I liked the idea from Satish of setting schedule for next 13 months as a job step.Answered | 11 Replies | 5104 Views | Created by ASHISH_TECHIT1 - Wednesday, December 26, 2012 9:55 AM | Last reply by ASHISH_TECHIT1 - Thursday, January 3, 2013 6:21 AM -
0 Votes
Agent Job enable but still not running as per the schedule
The requirement was as below: A data extraction Job Should run everyday @ 9 PM from 6th to 31st of the month and for every 3 hours on 1st to 5th ...Answered | 1 Replies | 5290 Views | Created by Madhuri.Teelair - Thursday, June 2, 2011 6:11 PM | Last reply by Todd C - Thursday, June 2, 2011 7:52 PM -
14 Votes
T-SQL to schedule running stored procedure every 3 hours
If I did not run job manually yet, then next scheduled run date is NULL.Answered | 16 Replies | 4390 Views | Created by marchelloua - Wednesday, April 10, 2019 10:34 AM | Last reply by Dedmon Dai - Thursday, April 11, 2019 7:58 AM -
0 Votes
Need solution on SQL Job Scheduling
But hardwiring scheduling logic into a procedure isn't neat, at all.Answered | 3 Replies | 2005 Views | Created by Forum Solution - Wednesday, November 7, 2012 7:52 AM | Last reply by TiborK - Thursday, November 8, 2012 9:45 AM -
0 Votes
schedule a month end -2 business days job in sql server?
No, the only way I know of would be to create a job that modifies its own schedule to set the next run date to the second to last day of the following month using ...Answered | 1 Replies | 6412 Views | Created by JNY - Tuesday, March 8, 2011 9:01 PM | Last reply by Jonathan Kehayias - Wednesday, March 9, 2011 1:59 AM -
0 Votes
Job Scheduler in Window Azure
Hi Nitin, @ present Azure SQL was not support for Job Scheduler so I think better way for you is Worker role.Answered | 10 Replies | 5102 Views | Created by Nitin Yadav MS - Thursday, January 10, 2013 11:58 AM | Last reply by Cotega Monitoring - Tuesday, May 7, 2013 2:47 AM -
0 Votes
How to create a SQL Agent job with the same Schedule Frequency as another job
But i did come up with this query that will show all the scheduling infor for a certain job name.Answered | 1 Replies | 756 Views | Created by TheBrenda - Tuesday, September 15, 2015 5:26 PM | Last reply by TheBrenda - Tuesday, September 15, 2015 5:54 PM -
1 Votes
SQL Agent job schedules
Hi Samantha, Based on my test, if the scheduled job runs longer than the scheduled interval time, it ignores the schedule interval time when ...Answered | 1 Replies | 1209 Views | Created by Samantha v - Monday, November 23, 2015 3:04 PM | Last reply by Ice Fan - Tuesday, November 24, 2015 9:59 AM -
1 Votes
Job schedule
Hi I blogged about a similar situation here ...Answered | 2 Replies | 1026 Views | Created by giri1231 - Wednesday, March 12, 2014 7:39 AM | Last reply by Prashant Kumar - Wednesday, March 12, 2014 10:04 AM - Items 1 to 20 of 1232311 Next ›
No announcements
