Search sqlserver-dba.com
Follow sqlserver-dba.com
*Use the Comments section for questions
SQLServer-DBA.com Links
Recent Posts
- How to list logins mapped to a database in SQL Server
- How to drop login on AWS RDS SQL Server without sysadmin using Hashicorp Vault
- How to get Cluster File Share Witness sharepath with Powershell
- A simple guide to Transparent Data Encryption in AWS RDS SQL Server
- A simple guide to Hashicorp and SQL Server Secrets Engine
- How to fix Warning: The certificate you created is expired
- SQLCMD uses OLEDB as a client interface
- A summary of creating a trust relationship between on-premises domain and AWS Directory Service
- Best practices for running Microsoft Active Directory Services on AWS
- SQL Server Blocking Reading List
How to schedule a SQL Server Agent Job to execute once a year -(Annually)
28 May,2014 by Tom Collins
Question: A business process requires me to schedule a SQL Server Agent Job to execute once a year (annually). How can I configure SQL Server Agent Scheduler?
Answer: Set Frequency
Occurs : Monthly
The 1st day of every 12 Months
Another question I see on forums asks about setting a job every 2 years. It is not possible to set the frequency for every 2 years with SQL Server Agent. As a DBA it may be prudent to request approval from business owners and other interested groups, many things can change over this timeframe .
Read More
SQL Agent Jobs – Schedule in seconds
How to create a SQL Server Security Audit - SQL Server DBA
Powershell sql server security audit
Author: Tom Collins (http://www.sqlserver-dba.com)
Share:
Verify your Comment
Previewing your Comment
This is only a preview. Your comment has not yet been posted.
As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.
Having trouble reading this image? View an alternate.
Posted by: |