a flowchart describing the process to apply to a job and make it automated in a way to ease it.
the flowchart show the start of applying to a job through mail, using MSSQLSERVER, i use a stored procedure that take the vacancy as the subject of the email and the email of the recruiter to insert into a determined table.
on insertion a trigger is fired, that take the inputs then create an Email using the database mail, and attach the CV and the personal photo.
also it writes a message in the body of the mail by default and it also can be specified by a group of previously stored messages.
then the mail is sent.