Solved

SQL Schedule Job

Posted on 2016-10-02
1
23 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 30

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

Ransomware-A Revenue Bonanza for Service Providers

Ransomware – malware that gets on your customers’ computers, encrypts their data, and extorts a hefty ransom for the decryption keys – is a surging new threat.  The purpose of this eBook is to educate the reader about ransomware attacks.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I have written a PowerShell script to "walk" the security structure of each SQL instance to find:         Each Login (Windows or SQL)             * Its Server Roles             * Every database to which the login is mapped             * The associated "Database User" for this …
In this article I will describe the Detach & Attach 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.
This Micro Tutorial hows how you can integrate  Mac OSX to a Windows Active Directory Domain. Apple has made it easy to allow users to bind their macs to a windows domain with relative ease. The following video show how to bind OSX Mavericks to …
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

786 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