Toad World® Forums

Auto generate report

Hi, does anyone know how to automatically generate a report from a query on a timely basis (e.g. Weekly or Monthly)?

This is an example query of a report (lets call it Report A):

select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID
from common_profile a, cis_ordactv b
where a.CIS_SVORDER = b.CIS_SVORDER

Your help is greatly appreciated :slight_smile:

On Wed, May 4, 2011 at 10:35 AM, Haris wrote:

Hi, does anyone know how to automatically generate a report from a query on a timely basis (e.g. Weekly or Monthly)?

M$ or UNIX? On UNIX there are crontabs (see
http://en.wikipedia.org/wiki/Cron). But you need to write a small
script with SQL*Plus.

cheers Sven

I have two reports that go out like that. One on Tuesday and Thursday, the other
at 9am and 3pm Monday thru Friday.

Sql output gets spooled to a comma delimited file with a .csv extension
(filename.csv)

batch file runs the sql

windows task scheduler runs the batch job

blat ( www.blat.net ) emails the file to a recipient list.

another batch file runs the blat

windows task scheduker runs the batch file (for the blat)

I’m sure ther are more complicated and sophisticated ways to do it, but this
is simple and it WORKS!!!

Contact me if you need further assistance.

On Wed, May 4, 2011 at 3:35 AM, Haris wrote:

Message from: whateveritis

Hi, does anyone know how to automatically generate a report from a query on
a timely basis (e.g. Weekly or Monthly)?

This is an example query of a report (lets call it Report A):

select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID
from common_profile a, cis_ordactv b
where a.CIS_SVORDER = b.CIS_SVORDER

Your help is greatly appreciated :)

Historical Messages

Author: Haris
Date: Wed May 04 01:35:24 PDT 2011
Hi, does anyone know how to automatically generate a report from a query on
a timely basis (e.g. Weekly or Monthly)?

This is an example query of a report (lets call it Report A):

select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID
from common_profile a, cis_ordactv b
where a.CIS_SVORDER = b.CIS_SVORDER

Your help is greatly appreciated :)

__
_______________________________________

Gene L. Bradley Jr.

Software Developer I

Information Systems & Integration

Jackson State University

1400 J R Lynch Street

P.O. Box 17750

Jackson, MS 39217

ph 601.979.1042

fax 601.371.9146

email gbradley@jsums.edu

Hi, does anyone know how to automatically generate a

report from a query on a timely basis (e.g. Weekly or Monthly)?

Not sure I understand your question. But you’d need:

Message from: GTDG

Maybe create something in the Automation Designer. Below is a basic app that
will export a dataset to xls, zip the xls, and send it via e-mail. Greg object
TarSaveGrid Enabled = True ID = 15 ParentID = 10 UserName = ‘Export Dataset1’
ActionSetID = 0 LastRunDate = 40667.554246909720000000 AllowEmptyFiles = False
AutoColumnWidth = False AutomaticallyDetectSchemaAndTable = False CloneCursor =
False CodePage = -1 CommitInterval = 0 ColumnNamesInValues = False
OneColumnPerLine = False DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0
Delimiter = 44 DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows =
False FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end


Historical Messages

Author: Gregory Liss
Date: Wed May 04 10:55:04 PDT 2011
Maybe create something in the Automation Designer. Below is a basic app that
will export a dataset to xls, zip the xls, and send it via e-mail. Greg object
TarSaveGrid Enabled = True ID = 15 ParentID = 10 UserName = ‘Export Dataset1’
ActionSetID = 0 LastRunDate = 40667.554246909720000000 AllowEmptyFiles = False
AutoColumnWidth = False AutomaticallyDetectSchemaAndTable = False CloneCursor =
False CodePage = -1 CommitInterval = 0 ColumnNamesInValues = False
OneColumnPerLine = False DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0
Delimiter = 44 DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows =
False FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end
__

Author: Simoneau, Roger
Date: Wed May 04 08:39:38 PDT 2011

Hi, does anyone know how to automatically generate a >> report from a query
on a timely basis (e.g. Weekly or Monthly)? Not sure I understand your question.
But you’d need:
__

Author: gene.l.bradley
Date: Wed May 04 02:46:12 PDT 2011
I have two reports that go out like that. One on Tuesday and Thursday, the other
at 9am and 3pm Monday thru Friday. Sql output gets spooled to a comma
delimited file with a .csv extension (filename.csv) batch file runs the sql
windows task scheduler runs the batch job blat ( www.blat.net ) emails the
file to a recipient list. another batch file runs the blat windows task
scheduker runs the batch file (for the blat) I’m sure ther are more
complicated and sophisticated ways to do it, but this is simple and it
WORKS!!! Contact me if you need further assistance. On
Wed, May 4, 2011 at 3:35 AM, Haris wrote: Message from: whateveritis Hi, does
anyone know how to automatically generate a report from a query on a timely
basis (e.g. Weekly or Monthly)? This is an example query of a report (lets call
it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID from
common_profile a, cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your help is
greatly appreciated :slight_smile: _______________________________________ Historical
Messages Author: Haris Date: Wed May 04 01:35:24 PDT 2011 Hi, does anyone know
how to automatically generate a report from a query on a timely basis (e.g.
Weekly or Monthly)? This is an example query of a report (lets call it Report
A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID from common_profile a,
cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your help is greatly
appreciated :slight_smile: __ _______________________________________ – Gene L. Bradley Jr.
Software Developer I Information Systems & Integration Jackson State University
1400 J R Lynch Street P.O. Box 17750 Jackson, MS 39217 ph 601.979.1042 fax
601.371.9146 email gbradley@jsums.edu
__

Author: Sven Aluoor
Date: Wed May 04 01:42:20 PDT 2011
On Wed, May 4, 2011 at 10:35 AM, Haris wrote: > Hi, does anyone know how to
automatically generate a report from a query on a timely basis (e.g. Weekly or
Monthly)? M$ or UNIX? On UNIX there are crontabs (see
http://en.wikipedia.org/wiki/Cron). But you need to write a small script with
SQL*Plus. cheers Sven
__

Author: Haris
Date: Wed May 04 01:35:24 PDT 2011
Hi, does anyone know how to automatically generate a report from a query on a
timely basis (e.g. Weekly or Monthly)?

This is an example query of a report (lets call it Report A):

select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID
from common_profile a, cis_ordactv b
where a.CIS_SVORDER = b.CIS_SVORDER

Your help is greatly appreciated :slight_smile:

__


Maybe create something in the Automation Designer.

Below is a basic app that will export a dataset to xls, zip the xls, and send it via e-mail.

Greg

object TarSaveGrid
Enabled = True
ID = 15
ParentID = 10
UserName = ‘Export Dataset1’
ActionSetID = 0
LastRunDate = 40667.554246909720000000
AllowEmptyFiles = False
AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False
CloneCursor = False
CodePage = -1
CommitInterval = 0
ColumnNamesInValues = False
OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’
DecimalPrecision = 0
Delimiter = 44
DiscardMax = -1
ExportFormat = efXLSFile
ExportSelectedRows = False
FieldSeparator = ‘;’
FileEncoding = feUTF8
HideTimeIfZero = False
IncludeCellBorders = False
IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False
IncludeNullText = False
IncludeSchema = True
IncludeSetDefineOff = True
IncludeSQLStatement = False
LaunchFileAfterCreation = False
LowerCaseColumnHeaders = False
LowerCaseColumnNames = False
MatchCellFonts = False
MDBFileExists = mdbfeAddTables
MDBTableExists = mdbteOverwrite
MemoFieldSize = 65536
NoPrecisionForIntegers = False
OneFileForMDB = False
OutputFilename = ‘c:\temp\output.xls’
PaperSize = psLetter
ParallelLoad = False
Params = <>
QuoteColumnHeaders = False
SheetName = ‘’
SQL.Strings = (
‘select * from scott.emp’)
SQLLoaderOperation = sloAppend
SQLLoaderRecoverable = False
StartAtActiveCell = False
StringEnclosure = ‘"’
StringQuoting = sqNoQuote
StringsAsStrings = False
ToClipboard = False
UnixStyleSave = False
UseGeneralFormatting = False
WordWrap = False
WriteWideString = False
XMLPlainNullFields = False
ZipResults = False
RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000}
Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000}
DatabaseObjects = {545046300C54617244424F626A6563747300054974656D730A000000000000}
end

object TarIfThenElse
Enabled = True
ID = 19
ParentID = 10
UserName = ‘If…Then…Else1’
ActionSetID = 0
LastRunDate = 40667.554248171300000000
RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000}
IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000}
ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000}
ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000}
end

Message from: whateveritis

^ Hi GTDG, thank you for your reply, my company is running Toad version 7.4.0.3

and I referred to this link

(http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx)
but I can’t seem to find Automation Designer :frowning:


Historical Messages

Author: Haris
Date: Wed May 04 19:19:58 PDT 2011
^ Hi GTDG, thank you for your reply, my company is running Toad version 7.4.0.3

and I referred to this link

(http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx)
but I can’t seem to find Automation Designer :frowning:

__

Author: Gregory Liss
Date: Wed May 04 10:55:04 PDT 2011
Maybe create something in the Automation Designer. Below is a basic app that
will export a dataset to xls, zip the xls, and send it via e-mail. Greg object
TarSaveGrid Enabled = True ID = 15 ParentID = 10 UserName = ‘Export Dataset1’
ActionSetID = 0 LastRunDate = 40667.554246909720000000 AllowEmptyFiles = False
AutoColumnWidth = False AutomaticallyDetectSchemaAndTable = False CloneCursor =
False CodePage = -1 CommitInterval = 0 ColumnNamesInValues = False
OneColumnPerLine = False DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0
Delimiter = 44 DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows =
False FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end
__

Author: Gregory Liss
Date: Wed May 04 10:55:04 PDT 2011
Message from: GTDG Maybe create something in the Automation Designer. Below is a
basic app that will export a dataset to xls, zip the xls, and send it via
e-mail. Greg object TarSaveGrid Enabled = True ID = 15 ParentID = 10 UserName =
‘Export Dataset1’ ActionSetID = 0 LastRunDate = 40667.554246909720000000
AllowEmptyFiles = False AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False CloneCursor = False CodePage = -1
CommitInterval = 0 ColumnNamesInValues = False OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0 Delimiter = 44
DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows = False
FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end
_______________________________________ Historical Messages Author: Gregory Liss
Date: Wed May 04 10:55:04 PDT 2011 Maybe create something in the Automation
Designer. Below is a basic app that will export a dataset to xls, zip the xls,
and send it via e-mail. Greg object TarSaveGrid Enabled = True ID = 15 ParentID
= 10 UserName = ‘Export Dataset1’ ActionSetID = 0 LastRunDate =
40667.554246909720000000 AllowEmptyFiles = False AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False CloneCursor = False CodePage = -1
CommitInterval = 0 ColumnNamesInValues = False OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0 Delimiter = 44
DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows = False
FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end __ Author: Simoneau, Roger Date: Wed
May 04 08:39:38 PDT 2011 >> Hi, does anyone know how to automatically generate a

report from a query on a timely basis (e.g. Weekly or Monthly)? Not sure I
understand your question. But you’d need: __ Author: gene.l.bradley Date:
Wed May 04 02:46:12 PDT 2011 I have two reports that go out like that. One on
Tuesday and Thursday, the other at 9am and 3pm Monday thru Friday. Sql output
gets spooled to a comma delimited file with a .csv extension (filename.csv)
batch file runs the sql windows task scheduler runs the batch job blat (
www.blat.net ) emails the file to a recipient list. another batch file runs
the blat windows task scheduker runs the batch file (for the blat) I’m
sure ther are more complicated and sophisticated ways to do it, but this is
simple and it WORKS!!! Contact me if you need further assistance.
On Wed, May 4, 2011 at 3:35 AM, Haris wrote: Message from:
whateveritis Hi, does anyone know how to automatically generate a report from a
query on a timely basis (e.g. Weekly or Monthly)? This is an example query of a
report (lets call it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID
from common_profile a, cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your
help is greatly appreciated :slight_smile: _______________________________________
Historical Messages Author: Haris Date: Wed May 04 01:35:24 PDT 2011 Hi, does
anyone know how to automatically generate a report from a query on a timely
basis (e.g. Weekly or Monthly)? This is an example query of a report (lets call
it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID from
common_profile a, cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your help is
greatly appreciated :slight_smile: __ _______________________________________ – Gene L.
Bradley Jr. Software Developer I Information Systems & Integration Jackson State
University 1400 J R Lynch Street P.O. Box 17750 Jackson, MS 39217 ph
601.979.1042 fax 601.371.9146 email gbradley@jsums.edu __ Author: Sven Aluoor
Date: Wed May 04 01:42:20 PDT 2011 On Wed, May 4, 2011 at 10:35 AM, Haris wrote:
Hi, does anyone know how to automatically generate a report from a query on a
timely basis (e.g. Weekly or Monthly)? M$ or UNIX? On UNIX there are crontabs
(see http://en.wikipedia.org/wiki/Cron). But you need to write a small script
with SQL*Plus. cheers Sven __ Author: Haris Date: Wed May 04 01:35:24 PDT 2011
Hi, does anyone know how to automatically generate a report from a query on a
timely basis (e.g. Weekly or Monthly)? This is an example query of a report
(lets call it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID from
common_profile a, cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your help is
greatly appreciated :slight_smile: __ _______________________________________
__

Author: Simoneau, Roger
Date: Wed May 04 08:39:38 PDT 2011

Hi, does anyone know how to automatically generate a >> report from a query
on a timely basis (e.g. Weekly or Monthly)? Not sure I understand your question.
But you’d need:
__

Author: gene.l.bradley
Date: Wed May 04 02:46:12 PDT 2011
I have two reports that go out like that. One on Tuesday and Thursday, the other
at 9am and 3pm Monday thru Friday. Sql output gets spooled to a comma
delimited file with a .csv extension (filename.csv) batch file runs the sql
windows task sch

^ Hi GTDG, thank you for your reply, my company is running Toad version 7.4.0.3 and I referred to this link (http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx) but I can’t seem to find Automation Designer :frowning:

Message from: GTDG

Ahhh. You won’t find it that far back. Hopefully you can upgrade or use one of
the other suggestions. Greg


Historical Messages

Author: Gregory Liss
Date: Wed May 04 19:23:33 PDT 2011
Ahhh. You won’t find it that far back. Hopefully you can upgrade or use one of
the other suggestions. Greg
__

Author: Haris
Date: Wed May 04 19:19:58 PDT 2011
^ Hi GTDG, thank you for your reply, my company is running Toad version 7.4.0.3

and I referred to this link

(http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx)
but I can’t seem to find Automation Designer :frowning:

__

Author: Haris
Date: Wed May 04 19:19:58 PDT 2011
Message from: whateveritis ^ Hi GTDG, thank you for your reply, my company is

running Toad version 7.4.0.3 and I referred to this link

(http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx)
but I can’t seem to find Automation Designer :frowning:
_______________________________________ Historical Messages Author: Haris Date:
Wed May 04 19:19:58 PDT 2011 ^ Hi GTDG, thank you for your reply, my company is

running Toad version 7.4.0.3 and I referred to this link

(http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx)
but I can’t seem to find Automation Designer :frowning: __ Author: Gregory Liss
Date: Wed May 04 10:55:04 PDT 2011 Maybe create something in the Automation
Designer. Below is a basic app that will export a dataset to xls, zip the xls,
and send it via e-mail. Greg object TarSaveGrid Enabled = True ID = 15 ParentID
= 10 UserName = ‘Export Dataset1’ ActionSetID = 0 LastRunDate =
40667.554246909720000000 AllowEmptyFiles = False AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False CloneCursor = False CodePage = -1
CommitInterval = 0 ColumnNamesInValues = False OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0 Delimiter = 44
DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows = False
FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end __ Author: Gregory Liss Date: Wed
May 04 10:55:04 PDT 2011 Message from: GTDG Maybe create something in the
Automation Designer. Below is a basic app that will export a dataset to xls, zip
the xls, and send it via e-mail. Greg object TarSaveGrid Enabled = True ID = 15
ParentID = 10 UserName = ‘Export Dataset1’ ActionSetID = 0 LastRunDate =
40667.554246909720000000 AllowEmptyFiles = False AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False CloneCursor = False CodePage = -1
CommitInterval = 0 ColumnNamesInValues = False OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0 Delimiter = 44
DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows = False
FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end
_______________________________________ Historical Messages Author: Gregory Liss
Date: Wed May 04 10:55:04 PDT 2011 Maybe create something in the Automation
Designer. Below is a basic app that will export a dataset to xls, zip the xls,
and send it via e-mail. Greg object TarSaveGrid Enabled = True ID = 15 ParentID
= 10 UserName = ‘Export Dataset1’ ActionSetID = 0 LastRunDate =
40667.554246909720000000 AllowEmptyFiles = False AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False CloneCursor = False CodePage = -1
CommitInterval = 0 ColumnNamesInValues = False OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0 Delimiter = 44
DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows = False
FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end __ Author: Simoneau, Roger Date: Wed
May 04 08:39:38 PDT 2011 >> Hi, does anyone know how to automatically generate a

report from a query on a timely basis (e.g. Weekly or Monthly)? Not sure I
understand your question. But you’d need: __ Author: gene.l.bradley Date:
Wed May 04 02:46:12 PDT 2011 I have two reports that go out like that. One on
Tuesday and Thursday, the other at 9am and 3pm Monday thru Friday. Sql output
gets spooled to a comma delimited file with a .csv extension (filename.csv)
batch file runs the sql windows task scheduler runs the batch job blat (
www.blat.net ) emails the file to a recipient list. another batch file runs
the blat windows task scheduker runs the batch file (for the blat) I’m
sure ther are more complicated and sophisticated ways to do it, but this is
simple and it WORKS!!! Contact me if you need further assistance.
On Wed, May 4, 2011 at 3:35 AM, Haris wrote: Message from:
whateveritis Hi, does anyone know how to automatically generate a report from a
query on a timely basis (e.g. Weekly or Monthly)? This is an example query of a
report (lets call it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID
from common_profile a, cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your
help is greatly appreciated :slight_smile: _______________________________________
Historical Messages Author: Haris Date: Wed May 04 01:35:24 PDT 2011 Hi, does
anyone know how to automatically generate a report from a query on a timely
basis (e.g. Weekly or Monthly)? This is an example query of a report (lets call
it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID from
common_profile a, cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your help is
greatly appreciated :slight_smile: __ _______________________________________ – Gene L.
Bradley Jr. Software Developer I Information Systems & Integration Jackson State
University 1400 J R Lynch Street P.O. Box 17750 Jackson, MS 39217 ph
601.979.1042 fax 601.371.9146 email gbradley@jsums.edu __ Author: Sven Aluoor
Date: Wed May 04 01:42:20 PDT 2011 On Wed, May 4, 2011 at 10:35 AM, Haris wrote:
Hi, does anyone know how to automatically generate a report from a query on a
timely basis (e.g. Weekly or Monthly)? M$ or UNIX? On UNIX there are crontabs
(see http://en.wikipedia.org/wiki/Cron). But you need to write a small script
with SQL*Plus. cheers Sven __ Author: Haris Date: Wed May 04 01:35:24 PDT 2011
Hi, does anyone know how to automatically generate a report from a query on a
timely basis (e.g. Weekly or Monthly)? This is an example query of a report
(lets call it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID from
common_

Ahhh. You won’t find it that far back. Hopefully you can upgrade or use one of the other suggestions.

Greg

Message from: whateveritis

^ too bad it didn’t featured in Toad 7.4, thanx for the help :slight_smile:

anyone knows any alternative?


Historical Messages

Author: Haris
Date: Wed May 04 19:53:14 PDT 2011
^ too bad it didn’t featured in Toad 7.4, thanx for the help :slight_smile:

anyone knows any alternative?

__

Author: Gregory Liss
Date: Wed May 04 19:23:33 PDT 2011
Ahhh. You won’t find it that far back. Hopefully you can upgrade or use one of
the other suggestions. Greg
__

Author: Gregory Liss
Date: Wed May 04 19:23:33 PDT 2011
Message from: GTDG Ahhh. You won’t find it that far back. Hopefully you can
upgrade or use one of the other suggestions. Greg
_______________________________________ Historical Messages Author: Gregory Liss
Date: Wed May 04 19:23:33 PDT 2011 Ahhh. You won’t find it that far back.
Hopefully you can upgrade or use one of the other suggestions. Greg __ Author:
Haris Date: Wed May 04 19:19:58 PDT 2011 ^ Hi GTDG, thank you for your reply, my

company is running Toad version 7.4.0.3 and I referred to this link

(http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx)
but I can’t seem to find Automation Designer :frowning: __ Author: Haris Date: Wed
May 04 19:19:58 PDT 2011 Message from: whateveritis ^ Hi GTDG, thank you for
your reply, my company is running Toad version 7.4.0.3 and I referred to this

link

(http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx)
but I can’t seem to find Automation Designer :frowning:
_______________________________________ Historical Messages Author: Haris Date:
Wed May 04 19:19:58 PDT 2011 ^ Hi GTDG, thank you for your reply, my company is

running Toad version 7.4.0.3 and I referred to this link

(http://toadworld.com/BLOGS/tabid/67/EntryId/601/Task-Automation-in-Toad®-Saving-You-Hours.aspx)
but I can’t seem to find Automation Designer :frowning: __ Author: Gregory Liss
Date: Wed May 04 10:55:04 PDT 2011 Maybe create something in the Automation
Designer. Below is a basic app that will export a dataset to xls, zip the xls,
and send it via e-mail. Greg object TarSaveGrid Enabled = True ID = 15 ParentID
= 10 UserName = ‘Export Dataset1’ ActionSetID = 0 LastRunDate =
40667.554246909720000000 AllowEmptyFiles = False AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False CloneCursor = False CodePage = -1
CommitInterval = 0 ColumnNamesInValues = False OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0 Delimiter = 44
DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows = False
FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end __ Author: Gregory Liss Date: Wed
May 04 10:55:04 PDT 2011 Message from: GTDG Maybe create something in the
Automation Designer. Below is a basic app that will export a dataset to xls, zip
the xls, and send it via e-mail. Greg object TarSaveGrid Enabled = True ID = 15
ParentID = 10 UserName = ‘Export Dataset1’ ActionSetID = 0 LastRunDate =
40667.554246909720000000 AllowEmptyFiles = False AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False CloneCursor = False CodePage = -1
CommitInterval = 0 ColumnNamesInValues = False OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0 Delimiter = 44
DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows = False
FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end
_______________________________________ Historical Messages Author: Gregory Liss
Date: Wed May 04 10:55:04 PDT 2011 Maybe create something in the Automation
Designer. Below is a basic app that will export a dataset to xls, zip the xls,
and send it via e-mail. Greg object TarSaveGrid Enabled = True ID = 15 ParentID
= 10 UserName = ‘Export Dataset1’ ActionSetID = 0 LastRunDate =
40667.554246909720000000 AllowEmptyFiles = False AutoColumnWidth = False
AutomaticallyDetectSchemaAndTable = False CloneCursor = False CodePage = -1
CommitInterval = 0 ColumnNamesInValues = False OneColumnPerLine = False
DateFormat = ‘Mm/Dd/Yyyy Hh:mm:ss’ DecimalPrecision = 0 Delimiter = 44
DiscardMax = -1 ExportFormat = efXLSFile ExportSelectedRows = False
FieldSeparator = ‘;’ FileEncoding = feUTF8 HideTimeIfZero = False
IncludeCellBorders = False IncludeColumnHeaders = True
IncludeDelimiterAfterLastColumn = False IncludeNullText = False IncludeSchema =
True IncludeSetDefineOff = True IncludeSQLStatement = False
LaunchFileAfterCreation = False LowerCaseColumnHeaders = False
LowerCaseColumnNames = False MatchCellFonts = False MDBFileExists =
mdbfeAddTables MDBTableExists = mdbteOverwrite MemoFieldSize = 65536
NoPrecisionForIntegers = False OneFileForMDB = False OutputFilename =
‘c:\temp\output.xls’ PaperSize = psLetter ParallelLoad = False Params =
QuoteColumnHeaders = False SheetName = ’ ’ SQL.Strings = ( ‘select * from
scott.emp’) SQLLoaderOperation = sloAppend SQLLoaderRecoverable = False
StartAtActiveCell = False StringEnclosure = ‘"’ StringQuoting = sqNoQuote
StringsAsStrings = False ToClipboard = False UnixStyleSave = False
UseGeneralFormatting = False WordWrap = False WriteWideString = False
XMLPlainNullFields = False ZipResults = False RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F457870
6F72742044617461736574310B416374696F6E5365744944020A0D416374696F
6E5365744E616D65060441707032024944020F084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500281F20E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303620504D3A20204578706F727420446174
617365743120284578706F727420446174617365742920737461727465642E06
4230352F30342F3230313120313A31383A303720504D3A20204578706F727420
446174617365743120284578706F72742044617461736574292066696E697368
65642E000653746174757307096173537563636573730000} Logins = {
545046300A544C6F67696E5265637300054974656D730A820100005450463009
544C6F67696E5265630011456E6372797074656450617373776F7264067D3138
2C302C302C302C3231352C3132322C3136302C3131342C3233392C34312C3231
352C34392C3139302C3135352C3233372C34392C3133372C3133312C3137362C
3230372C3138302C3137342C3232372C32322C3139302C3137352C352C313335
2C34322C32322C38312C32312C3231342C3135362C3230322C34330455736572
0605474C49535306536572766572060858452E574F524C440850726F746F636F
6C0603544E530B4C617374436F6E6E656374050090741B318CDB9E0E4009436F
6E6E656374417306064E4F524D414C05436F6C6F7204FFFFFF00064E756D6265
7202000A4F7261636C65486F6D650621633A5C4F7261636C655C70726F647563
745C31312E322E305C636C69656E745F310B4175746F436F6E6E656374080C53
61766550617373776F726408084661766F7269746508064D6574686F64020014
437573746F6D4669656C64732E537472696E67730112000000000000000000} DatabaseObjects
= {545046300C54617244424F626A6563747300054974656D730A000000000000} end object
TarIfThenElse Enabled = True ID = 19 ParentID = 10 UserName = ‘If…Then…Else1’
ActionSetID = 0 LastRunDate = 40667.554248171300000000 RunData = {
545046300A54617252756E44617461000A416374696F6E4E616D65060F49662E
2E5468656E2E2E456C7365310B416374696F6E5365744944020A0D416374696F
6E5365744E616D650604417070320249440213084661696C4D6F6465070A666D
436F6E74696E75650752756E446174650500984935E38DDB9E0E400752756E55
7365720605676C697373104D657373616765732E537472696E67730106413035
2F30342F3230313120313A31383A303720504D3A202049662E2E5468656E2E2E
456C736531202849662E2E5468656E2E2E456C73652920737461727465642E06
4230352F30342F3230313120313A31383A303820504D3A202049662E2E546865
6E2E2E456C736531202849662E2E5468656E2E2E456C7365292066696E697368
65642E000653746174757307096173537563636573730000} IfItems = {
545046301254617245786563757461626C654974656D7300054974656D730AC9
000000545046300D54617246696C654578697374730007456E61626C65640902
4944021008506172656E744944021308557365724E616D65060C46696C652045
7869737473310B416374696F6E536574494402000846696C656E616D65061243
3A5C74656D705C6F75747075742E786C730752756E446174610A4C0000005450
46300A54617252756E44617461000B416374696F6E536574494402FF02494402
FF084661696C4D6F6465070A666D436F6E74696E756506537461747573070961
7353756363657373000000000000} ThenItems = {
545046301254617245786563757461626C654974656D7300054974656D730A4C
060000545046300D5461725A6970417263686976650007456E61626C65640902
4944021108506172656E744944021308557365724E616D650608417263686976
65310B416374696F6E5365744944020014457874726163744F76657277726974
654D6F646507076F6D4E657665720846696C656E616D650612633A5C74656D70
5C6F75747075742E7A6970135265706C6163654578697374696E6746696C6509
0C5A6970446972656374696F6E07057A645A69700752756E446174610A4C0000
00545046300A54617252756E44617461000B416374696F6E536574494402FF02
494402FF084661696C4D6F6465070A666D436F6E74696E756506537461747573
07096173537563636573730000085A69704974656D730AD6000000545046300F
5461724469736B5A69704974656D7300054974656D730AB4000000545046300E
5461724469736B5A69704974656D00044E616D650612433A5C74656D705C6F75
747075742E786C730A45786563757461626C6509084973466F6C646572081043
6F6D7072657373696F6E4C6576656C07097A636C4E6F726D616C0B444F533833
466F726D6174080C46756C6C50617468496E666F080A47726F7570496E646578
020011496E636C756465537562466F6C6465727308095A6970416374696F6E07
0C7A6161557064617465416464000000000000545046300D5461724966546865
6E456C73650007456E61626C656409024944021508506172656E744944021308
557365724E616D65060F49662E2E5468656E2E2E456C7365320B416374696F6E
536574494402000752756E446174610A4C000000545046300A54617252756E44
617461000B416374696F6E536574494402FF02494402FF084661696C4D6F6465
070A666D436F6E74696E75650653746174757307096173537563636573730000
0749664974656D730AEE000000545046301254617245786563757461626C6549
74656D7300054974656D730AC9000000545046300D54617246696C6545786973
74730007456E61626C656409024944021208506172656E744944021508557365
724E616D65060C46696C6520457869737473320B416374696F6E536574494402
000846696C656E616D650612633A5C74656D705C6F75747075742E7A69700752
756E446174610A4C000000545046300A54617252756E44617461000B41637469
6F6E536574494402FF02494402FF084661696C4D6F6465070A666D436F6E7469
6E7565065374617475730709617353756363657373000000000000095468656E
4974656D730A8E010000545046301254617245786563757461626C654974656D
7300054974656D730A69010000545046300E546172456D61696C416374696F6E
0007456E61626C656409024944021708506172656E744944021508557365724E
616D650606456D61696C310B416374696F6E5365744944020013417474616368
6D656E74732E537472696E6773010612433A5C74656D705C6F75747075742E7A
69700007456D61696C546F061D796F75722E626F737365732E656D61696C4079
6F75726F72672E636F6D0446726F6D0616796F75722E656D61696C40796F7572
6F72672E636F6D04486F73740616796F75722E736D74702E72656C61792E7365
727665720A496D706F7274616E6365020104506F72740219075375626A656374
060B6F75747075742066696C650C557365436C6970626F617264080752756E44
6174610A4C000000545046300A54617252756E44617461000B416374696F6E53
6574494402FF02494402FF084661696C4D6F6465070A666D436F6E74696E7565
06537461747573070961735375636365737300000000000009456C7365497465
6D730A06010000545046301254617245786563757461626C654974656D730005
4974656D730AE1000000545046300A5461724D6573736167650007456E61626C
656409024944021808506172656E744944021508557365724E616D6506084D65
7373616765320B416374696F6E5365744944020007427574746F6E730B046D62
4F4B086D6243616E63656C0007446C675479706507076D744572726F72034D73
67060D652D6D61696C206661696C65640752756E446174610A4C000000545046
300A54617252756E44617461000B416374696F6E536574494402FF02494402FF
084661696C4D6F6465070A666D436F6E74696E75650653746174757307096173
5375636365737300000000000000000000} ElseItems = {
545046301254617245786563757461626C654974656D7300054974656D730AEE
000000545046300A5461724D6573736167650007456E61626C65640902494402
1408506172656E744944021308557365724E616D6506084D657373616765310B
416374696F6E5365744944020007427574746F6E730B046D624F4B086D624361
6E63656C0007446C675479706507076D744572726F72034D7367061A4F757470
75742066696C6520646F6573206E6F742065786973740752756E446174610A4C
000000545046300A54617252756E44617461000B416374696F6E536574494402
FF02494402FF084661696C4D6F6465070A666D436F6E74696E75650653746174
75730709617353756363657373000000000000} end __ Author: Simoneau, Roger Date: Wed
May 04 08:39:38 PDT 2011 >> Hi, does anyone know how to automatically generate a

report from a query on a timely basis (e.g. Weekly or Monthly)? Not sure I
understand your question. But you’d need: __ Author: gene.l.bradley Date:
Wed May 04 02:46:12 PDT 2011 I have two reports that go out like that. One on
Tuesday and Thursday, the other at 9am and 3pm Monday thru Friday. Sql output
gets spooled to a comma delimited file with a .csv extension (filename.csv)
batch file runs the sql windows task scheduler runs the batch job blat (
www.blat.net ) emails the file to a recipient list. another batch file runs
the blat windows task scheduker runs the batch file (for the blat) I’m
sure ther are more complicated and sophisticated ways to do it, but this is
simple and it WORKS!!! Contact me if you need further assistance.
On Wed, May 4, 2011 at 3:35 AM, Haris wrote: Message from:
whateveritis Hi, does anyone know how to automatically generate a report from a
query on a timely basis (e.g. Weekly or Monthly)? This is an example query of a
report (lets call it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID
from common_profile a, cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your
help is greatly appreciated :slight_smile: _______________________________________
Historical Messages Author: Haris Date: Wed May 04 01:35:24 PDT 2011 Hi, does
anyone know how to automatically generate a report from a query on a timely
basis (e.g. Weekly or Monthly)? This is an example query of a report (lets call
it Report A): select a.AGREE_PERIOD, b.CIS_SVORDER, a.USER_ID from
common_profile a, cis_ordactv b where a.CIS_SVORDER = b.CIS_SVORDER Your help is
greatly appreciated :slight_smile: __ _______________________________________ – Gene L.
Bradley Jr. Software Developer I Information Systems & Integration Jackson State
University 1400 J R Lynch Street P.O. Box 17750 Jackson, MS 39217 ph
601.979.1042 fax 601.371.9146 email gbradley@jsums.edu __ Author: Sven Aluoor
Date: Wed May 04 01:42:20 PDT 2011 On Wed, May 4, 2011 at 1

^ too bad it didn’t featured in Toad 7.4, thanx for the help :slight_smile:

anyone knows any alternative?