var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: sending query results as a database email
I have started my new intern job where my first task is below..
So My data base is DB1
I have some 120 tables in that
I have one particular table which is oraganization
My job is to run a query "select * from organization"
and the results that i get, I have to send it to my email ID.. but not manually by exporting a file,
It should be automated. Itll need to run every night automatically without anyone doing anything. Is that possible?
My work so far::
I have created a new profile and associated an account to it using database mail node in the sql server management studio
Any help is greatly appreciated..