December 17, 2021 at 5:37 pm
Hi All,
After a long time posting my query. It would be great help if anyone can assist on this.
I would to like to create one schedule for sql job which should run after every 1 week from the active start date.
For Example :
If active start date of the job is in MM/DD/YYYY : 12/17/2021 ;then the next schedule should be after 1 week only i.e 12/24/2021 ; Next to next schedule would be : 12/31/2012 this way..
Thanks in Advance .
December 17, 2021 at 8:15 pm
That is a standard type of schedule in SQL Server agent - what issue are you having setting it up?
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 20, 2021 at 2:25 pm
Hi Jeffrey,
I am not getting this facility in SSMS. I think it is possible only through tsql script .
December 20, 2021 at 6:51 pm
Can you run SELECT @@version in a query window connected to that instance? Either you are running SQL Server Express or you do not have permissions to the agent.
Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”
― Charles R. Swindoll
How to post questions to get better answers faster
Managing Transaction Logs
December 21, 2021 at 6:46 pm
If you have source control at your shop (like GIT) you may be able to see how other Jobs are scripted and pull out the block of code that defines the schedule. Depending on your permissions, implementing this would be another matter.
----------------------------------------------------
December 24, 2021 at 5:51 am
This was removed by the editor as SPAM
December 24, 2021 at 5:51 am
This was removed by the editor as SPAM
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply