Password Reset for Employee Role every 90 days

Running this script on the main passageways Database (Production_Portal_PortalFX/Passageways) will reset all users in the employee role so that the next time they login to the portal (Forms Authentication) they will be forced to change their password.

update PWUser
set passwordresetflag='1'
WHERE (UserID IN
(SELECT UserID
FROM PWRoleMembers
WHERE (RoleID = 'Employee')))

In SQL you can navigate to SQL Server Agent, Right Click Jobs, New Job.

General - Give Job a name and description

Steps - Step Name, select database to run script on and paste the above SQL script into command box.

Schedules - Schedule Name, Schedule type: Recurring, Occurs Monthly, Day xx of every 3 months, select an after hours time (5:00 AM?), Select Start date  with No End Date.

Alerts - Can set this up if you wish it isn't necessary

Notifications - Can set this up if you wish it isn't necessary

Targets - n/a