create a Season job (a job with once schedule in 3 month)

Asked Mar 27 '23 at 05:46

Active Mar 27 '23 at 13:53

Viewed 33 times

we have an archive process for 6 databases and we take a backup from each database and move to tape, In the following, I restore the same raw database, we must do this exactly at the end of the session but sometimes we forgot to do that, I want to create a job to remind me each 3 months with email, thank you.

it's better to take a log of this process into a table.

edited Mar 27 '23 at 13:53

asked Mar 27 '23 at 05:46

mehdi rahmanzadeh

1

What's the question exactly? And have you considered SQL Agent? – Charlieface Mar 27 '23 at 09:27
i want to create a job to be run once in every 3 month – mehdi rahmanzadeh Mar 27 '23 at 13:54
Put this as a recurring event in whatever calendar system you use. No need for anything SQL Server specific here. – Joel Coehoorn Mar 27 '23 at 14:09
I understand that's what you want but what is the question? Have you tried it? What were your results? Did you get an error, some other problem? – Charlieface Mar 27 '23 at 14:16
https://learn.microsoft.com/en-us/sql/relational-databases/system-stored-procedures/sp-add-schedule-transact-sql?view=sql-server-ver16 – Charlieface Mar 27 '23 at 14:17
yes, i attending to create a job but job schedule nothing has more than 1 month and i need to schedule once in the end of season, that is my problem. – mehdi rahmanzadeh Mar 27 '23 at 14:49
Just do 122 days? – Charlieface Mar 28 '23 at 00:12
realy ? is it ok ? – mehdi rahmanzadeh Mar 28 '23 at 05:50

create a Season job (a job with once schedule in 3 month)

0 Answers0