Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

How to set yearly jobs in Sql Server Agent

I want to add 12 credits to 2 columns of a table. I want to do this every 6 months. But there seem to be no such option in Job Schedule Properties.

Also, what should be the job statement if I want to show a log of credits and debits to the admin. Explained better at:

EDIT : Having solved half the problem, here is the other half of it.

The admin should be shown a record of the credit and debit of leaves taking place in each user account, like a log. How do I show this in a gridview or table or any way? Example, when admin logs in and selects an employee name to view their leave balance-sheet, it should look something like below

enter image description here

Now, the admin should be able to add leaves when an employee cashes his leaves,by clicking on the Credit Leaves button. ALSO, yearly log should be displayed and on changing year, that year's log should be displayed.

Please give me some idea about what should be the steps for this server agent job.

like image 609
avneesh Avatar asked Jan 26 '26 17:01

avneesh


2 Answers

On the first day of every 6 months starting from January:

On the first day of every 6 months starting from January

like image 143
ScubaManDan Avatar answered Jan 28 '26 11:01

ScubaManDan


Set the first day of every 12 months.

It is second option under selected dropdown list.

like image 24
Anton Avatar answered Jan 28 '26 12:01

Anton



Donate For Us

If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!