Solved

SQL Schedule Job

Posted on 2016-10-02
1
20 Views
Last Modified: 2016-10-02
Hello,

I have created a SQL Job to run on the 1st day of every month at 2.30am.
I am unsure if I have setup the frequency correct as the schedule properties gives two options to run.
Currently I have set it to use the first radio button ‘Day’ on the first day of every 1 month.
Please see attached example of a screen shot, would someone mind giving me confirmation this is correct?
Thank you.
SQLJob.png
0
Comment
Question by:jspc
1 Comment
 
LVL 29

Accepted Solution

by:
Rich Weissler earned 500 total points
ID: 41825641
Yes, your settings are correct.  You can also look at the description at the bottom of the page.  Final confirmation -- after you set a job on this schedule, you can look in the Job monitor, and look at the date/time that the system will next run your job.
0

Featured Post

How your wiki can always stay up-to-date

Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
- Increase transparency
- Onboard new hires faster
- Access from mobile/offline

Join & Write a Comment

Suggested Solutions

Long way back, we had to take help from third party tools in order to encrypt and decrypt data.  Gradually Microsoft understood the need for this feature and started to implement it by building functionality into SQL Server. Finally, with SQL 2008, …
In this article I will describe the Backup & Restore method as one possible migration process and I will add the extra tasks needed for an upgrade when and where is applied so it will cover all.
It is a freely distributed piece of software for such tasks as photo retouching, image composition and image authoring. It works on many operating systems, in many languages.
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

22 Experts available now in Live!

Get 1:1 Help Now