Scheduling SQL Server 2005 report server

I'm looking a way to schedule a report to be generated in pre-define time and push it out to my users through email or file share any format (excell, Word, etc). Any help would be greatly appreciated.

When you view the report in a browser you'll see four tabs - View, Properties, History, Subscriptions. Create a new subscription and then enter the recipient (actual email address required) and select the Render Format as Excel, PDF, Web Archive etc. You can also set the date, time and frequency of the subscription.

Hope this helps,

Aidan

Scheduling SQL / ASP

Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, DominicCheck out Jobs in the BOL. Each job can have multiple steps and multiple
schedules. Each step can be VBScript or T-SQL or OS command or ...
--
Tom
---
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com/sql
"Dominic Marsat" <djmarsatAThotmail.com> wrote in message
news:eqXtuuGKEHA.2380@.TK2MSFTNGP09.phx.gbl...
Hi,
I've been asked to help with the automation of a nightly flat file
extraction of data from a SQL server (I think it's MS SQL 2000), i.e.
producing a text file containing specific data.
I have read previously in other news groups methods of scheduling ASP
pages/VB
scripts that could accomplish this task.
Is it possible to achieve this solely via the SQL server instead of using
ASP/VB scripts?
Thanks, Dominicsql

Scheduling Report to render in to PDF format

Hi,
I have a report with 25 subreports which needs to generate one pdf file on
schedule basis (ie. schedule report to render in to PDF format based on some
time and date setting).
Is there any way of doing this?
Thanks in advance for the helper.
Regards.
AnithaYou need to subscribe to the report. As part of the subscription parameters
you can define the schedule of when you want the report to be automatically
generated.
Keep in mind that you have to also define a dafault value for each parameter
in your report.
Hope this helps,
Tigan
"Anitha Naidu" wrote:
> Hi,
> I have a report with 25 subreports which needs to generate one pdf file on
> schedule basis (ie. schedule report to render in to PDF format based on some
> time and date setting).
> Is there any way of doing this?
> Thanks in advance for the helper.
> Regards.
> Anitha
>

scheduling from Excel to SQL Server

how do i automatically import an excel file to sql server every 12 hours?Use scheduled DTS job in Enterprise manager.

Good Luck.sql

Scheduling a text file to be inserted to a database table

Hi there
New to SQL 2000 and i have a question regarding scheduling a task. I have a
text file that is being downloaded to a web folder from an AS400 system
three times a day. I want to then grab this file and insert and replace the
exisiting records in a database table.
What be the best way to do this? Stored Procedure?
Can you schedule stored procedures to be run at time specific intervals?
Any help appreciatedBJ
DTS Package
"bj" <orders@.seton.net.au> wrote in message
news:OifAtnhUGHA.5808@.TK2MSFTNGP12.phx.gbl...
> Hi there
> New to SQL 2000 and i have a question regarding scheduling a task. I have
> a text file that is being downloaded to a web folder from an AS400 system
> three times a day. I want to then grab this file and insert and replace
> the exisiting records in a database table.
> What be the best way to do this? Stored Procedure?
> Can you schedule stored procedures to be run at time specific intervals?
> Any help appreciated
>
>

Scheduling a .sql file through "jobs"

This is going to be a stupid, easy question; but I'm a SQL Server Newbie, so
here goes...
I have a .sql file that I need to schedule to run through SQL Server. The
actual SQL in it is too large to be pasted into the Exec Transact-SQL screen
on the scheduler. Is there a way to just call the .sql file from
transact-sql? Something like, "exec c:\scripts\analyzedb.sql", or something
along those lines? I've just been looking and looking for this, and can't
find it... thanks for any help anyone can give me.
Set the type of your jobstep to CmdExec instead of TSQL. CmdExec steps can
run commandline commands and batch files. You can then use the SQL Server
command line tool to run the script. The syntax for this is something like:
osql -E -i yourfilename.sql
For more details on osql see Books Online.
Jacco Schalkwijk
SQL Server MVP
"Amy" <Amy@.discussions.microsoft.com> wrote in message
news:999685D4-886D-42B0-A24A-F8A4FEBCAE00@.microsoft.com...
> This is going to be a stupid, easy question; but I'm a SQL Server Newbie,
> so
> here goes...
> I have a .sql file that I need to schedule to run through SQL Server. The
> actual SQL in it is too large to be pasted into the Exec Transact-SQL
> screen
> on the scheduler. Is there a way to just call the .sql file from
> transact-sql? Something like, "exec c:\scripts\analyzedb.sql", or
> something
> along those lines? I've just been looking and looking for this, and can't
> find it... thanks for any help anyone can give me.
>
|||Thanks, Jacco! That was just what I needed to know... :-)
"Jacco Schalkwijk" wrote:

> Set the type of your jobstep to CmdExec instead of TSQL. CmdExec steps can
> run commandline commands and batch files. You can then use the SQL Server
> command line tool to run the script. The syntax for this is something like:
> osql -E -i yourfilename.sql
> For more details on osql see Books Online.
> --
> Jacco Schalkwijk
> SQL Server MVP
>
> "Amy" <Amy@.discussions.microsoft.com> wrote in message
> news:999685D4-886D-42B0-A24A-F8A4FEBCAE00@.microsoft.com...
>
>

Scheduled sql cannot access the network drives?

I have a stored procedure performing several tsql operations with MS
Access and Excel files stored into the network file system, and
therefore using OpenDataSouce with these files in the network,
accessible through mapped network drives.

My user has a profile that maps the necessary network drives at boot.
SQL Server runs on the server with an account created for that. This
accont has also a profile mapping the necessary network drives.

The stored procedure runs fine only if I launch it with SQL Server
Management Studio on the server, logging in directly on the server (at
this point the network drives are mapped correctly).

If I launch the Stored Procedure with SQL Server Management Studio on
my client, it doesn't find the network drives and fails.

The same happens when I schedule the stored procedure on the server
with SQL Server Agent, which runs with an account performing the
mapping in its profile.

Any ideas how to make it work?

A suggestion in common, don′t use mapped network driver, use UNC paths !

If you want to use ressources within the network you will need appropiate permissions either for the service account SQL Server Service is running with or the service account SQL Server Agent is running with (if you do that within a scheduled job). An alternative would be to setup a proxy account for the service [1]

[1] http://www.databasejournal.com/features/mssql/article.php/1580041

In SQL Server 2005 proxy accounts can also be configured through the Configuration interface which you will find in the program collection.

HTH, Jens SUessmeyer.

http://www.sqlserver2005.de

Scheduled Jobs

When creating a scheduled job is it possible to output the file to a shared drive on the network
When browsing for file location whien creating the job only local physical drives are shown and when inputting unc share the job fails
any ideas ?If you know the name/IP address of the network file then you can output the file by using:

\\servername\d$\data\filename.dat

where 'd$' is the drive you're writing to on that server.

(NB This doesn't work if you are doing any file handling using the Scripting Runtime DLL through T-SQL)

Scheduled DTS package not running

I have created a DTS package to read data from a SQL Server table and copy it to an Excel file on one sheet. I have tested the DTS package manually and it runs. I scheduled the package but it keeps failing giving the following error message. The path to the Excel file is valid and the SQL server is connected to the server where the Excel file resides.

... DTSRun: Executing... DTSRun OnStart: Copy Data from vw_Symbols to vw_Symbols$ Step DTSRun OnError: Copy Data from vw_Symbols to vw_Symbols$ Step, Error = -2147467259 (80004005) Error string: 'S:\Mission Critical Enterprises\Current Projects\JPMC Aperture Rollout 05-100-1-0001\Symbol Requests\JPMC - Symbols Added.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error source: Microsoft JET Database Engine Help file: Help context: 5003044 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534774783 (E01FFC01) Error string: 'S:\Mission Critical Enterprises\Current Projects\JPMC Aperture Rollout 05-100-1-0001\Symbol Requests\JPMC - Symbols Added.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error sour... Process Exit Code 1. The step failed.

Is S:\ a network-shared drive?

The Agent runs your package under its own account, so if S:\ is a network drive mapped under your account, it might not be visible to Agent's account.

You may create Agent Proxy to make package run under your account.|||

I have a same or pretty similar problem, but in my case it′s when a trying to schedule a DTS and leave a file in a share point tool. If you have some information or tips I will appreciate it.

This is the message error.

Executed as user: Server Name\CRMSandbox. ...Step_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failur... Process Exit Code 2. The step failed.

Thanks.

Miguel

|||

Hi, with regards to creating "Agnet Proxy" have you any further information regarding this?

Thank you.

|||Search for "Creating SQL Server Agent Proxies" in Books Online.

Scheduled DTS package not running

I have created a DTS package to read data from a SQL Server table and copy it to an Excel file on one sheet. I have tested the DTS package manually and it runs. I scheduled the package but it keeps failing giving the following error message. The path to the Excel file is valid and the SQL server is connected to the server where the Excel file resides.

... DTSRun: Executing... DTSRun OnStart: Copy Data from vw_Symbols to vw_Symbols$ Step DTSRun OnError: Copy Data from vw_Symbols to vw_Symbols$ Step, Error = -2147467259 (80004005) Error string: 'S:\Mission Critical Enterprises\Current Projects\JPMC Aperture Rollout 05-100-1-0001\Symbol Requests\JPMC - Symbols Added.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error source: Microsoft JET Database Engine Help file: Help context: 5003044 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534774783 (E01FFC01) Error string: 'S:\Mission Critical Enterprises\Current Projects\JPMC Aperture Rollout 05-100-1-0001\Symbol Requests\JPMC - Symbols Added.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error sour... Process Exit Code 1. The step failed.

Is S:\ a network-shared drive?

The Agent runs your package under its own account, so if S:\ is a network drive mapped under your account, it might not be visible to Agent's account.

You may create Agent Proxy to make package run under your account.|||

I have a same or pretty similar problem, but in my case it′s when a trying to schedule a DTS and leave a file in a share point tool. If you have some information or tips I will appreciate it.

This is the message error.

Executed as user: Server Name\CRMSandbox. ...Step_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failur... Process Exit Code 2. The step failed.

Thanks.

Miguel

|||

Hi, with regards to creating "Agnet Proxy" have you any further information regarding this?

Thank you.

|||Search for "Creating SQL Server Agent Proxies" in Books Online.

Scheduled DTS package not running

I have created a DTS package to read data from a SQL Server table and copy it to an Excel file on one sheet. I have tested the DTS package manually and it runs. I scheduled the package but it keeps failing giving the following error message. The path to the Excel file is valid and the SQL server is connected to the server where the Excel file resides.

... DTSRun: Executing... DTSRun OnStart: Copy Data from vw_Symbols to vw_Symbols$ Step DTSRun OnError: Copy Data from vw_Symbols to vw_Symbols$ Step, Error = -2147467259 (80004005) Error string: 'S:\Mission Critical Enterprises\Current Projects\JPMC Aperture Rollout 05-100-1-0001\Symbol Requests\JPMC - Symbols Added.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error source: Microsoft JET Database Engine Help file: Help context: 5003044 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -534774783 (E01FFC01) Error string: 'S:\Mission Critical Enterprises\Current Projects\JPMC Aperture Rollout 05-100-1-0001\Symbol Requests\JPMC - Symbols Added.xls' is not a valid path. Make sure that the path name is spelled correctly and that you are connected to the server on which the file resides. Error sour... Process Exit Code 1. The step failed.

Is S:\ a network-shared drive?

The Agent runs your package under its own account, so if S:\ is a network drive mapped under your account, it might not be visible to Agent's account.

You may create Agent Proxy to make package run under your account.|||

I have a same or pretty similar problem, but in my case it′s when a trying to schedule a DTS and leave a file in a share point tool. If you have some information or tips I will appreciate it.

This is the message error.

Executed as user: Server Name\CRMSandbox. ...Step_DTSExecuteSQLTask_1 DTSRun OnError: DTSStep_DTSExecuteSQLTask_1, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 DTSRun OnFinish: DTSStep_DTSExecuteSQLTask_1 DTSRun OnStart: DTSStep_DTSExecuteSQLTask_2 DTSRun OnError: DTSStep_DTSExecuteSQLTask_2, Error = -2147467259 (80004005) Error string: Failure creating file. Error source: Microsoft JET Database Engine Help file: Help context: 5003436 Error Detail Records: Error: -2147467259 (80004005); Provider Error: -329978796 (EC54EC54) Error string: Failur... Process Exit Code 2. The step failed.

Thanks.

Miguel

|||

Hi, with regards to creating "Agnet Proxy" have you any further information regarding this?

Thank you.

|||Search for "Creating SQL Server Agent Proxies" in Books Online.

Scheduled DTS not running

I created a DTS Local Package that should run on a specified time (ex. 9:00 AM) using EnterPrise Manager on my PC.

It is basically copying a file from our AS400 to the SQL server. It works fine if you execute it but the scheduler does not run at the specified time.

Am I missing anything here?

TIFOriginally posted by ARPRINCE
I created a DTS Local Package that should run on a specified time (ex. 9:00 AM) using EnterPrise Manager on my PC.

It is basically copying a file from our AS400 to the SQL server. It works fine if you execute it but the scheduler does not run at the specified time.

Am I missing anything here?

TIF

chk if SQL Agent is started|||Yup. The Agent is running. When I checked the jobs, I see an "X" on the DTS job I created and says that it failed. However, I can't see a log that gives me the exact reason why it failed.|||Check your Agent service account has permission on AS 400 server!|||When I configured my DTS, I entered the AS400 user credentials so I figured this is enough since when I execute my DTS, in works just fine. It's only when I use the schedule that it doesn't work.

How do you check anagent service account permission on a AS400? Sorry, I'm relatively new using this DTS thing.

Thanks|||can you just check sql agent error, see what it says!!
Agent right-click--Display error log.|||Don't forget that when you interactivly run a DTS package, it runs under your credentials. When SQLAgent runs it, it runs with the permissions given to SQLAgent. Maybe you have permissions to access the AS400 but SQLAgent does not??|||Originally posted by tomh53
Don't forget that when you interactivly run a DTS package, it runs under your credentials. When SQLAgent runs it, it runs with the permissions given to SQLAgent. Maybe you have permissions to access the AS400 but SQLAgent does not??

I see the error log but it does not show my any logs for yesterday and today. As a matter of fact, the last log date is 2/15/2004.|||Probably Agent configured to clear all jobhistory logs..
In anycase as tom said, look into SQLAgent service account has permission to connect AS400. When you run it manually it takes your credentials..when it runs under SqlAgent it looks for SqlAgent service account.|||Thanks for the TIPs. I will look into it more thoroughly.

Scheduled DTS job to run a cmd file not working

Hi,

I have created a DTS job that contains one 'Execute SQL Task' job. This SQL task runs a cmd file. The cmd file runs a few windows commands and then runs a Micorosoft Access Macro. Once finished both access and the cmd screen close down.

If I open up the DTS job and execute it manually, it works fine (takes about 1/2 an hour to run). My problem is that when I schedule the DTS job, the job starts up at the correct time but it never actually starts running the cmd file and it gives no error. It says Executing until I actually stop the job manually.

The Job details are:

Type: Operating System Command [CmdExec]

Command: DTSRun /~Z0x2F3FF84472BB6E7FF356EB006BA1AEC62C95AB3BF506F3 4A241F228CE148AB09DBC66B8651A450B725E6C4E6A1D328E4 EC2F2C0F8E323F1C7D501FD5B8FD00E25656514AF2224407DB 1C569163CBE383A8E7D8BE4974A0911F5CEB

The DTS details are:

C:\Batches\DTSrunofUpdatesqlpmi.cmd

The cmd program details are:

echo on
:Start

if not exist "c:\apps\CI_Databases\pmi\pmiload.mdb" exit

rem cleanup unfinsihed runs
if exist "c:\apps\CI_Databases\pmi\pmiload.mdb" if exist "c:\apps\CI_Databases\pmi\pmiloadold.mdb" del "c:\apps\CI_Databases\pmi\pmiloadold.mdb"

rem main file locked assume its being work on so don't run this job.
if exist "c:\apps\CI_Databases\pmi\pmiload.ldb" exit

rem if a tmp exits then the last job never completed - continue to add to tmp file

if exist "c:\apps\CI_Databases\pmi\pmiloadtmp.mdb" goto Load

copy "c:\apps\CI_Databases\pmi\pmiload.mdb" "c:\apps\CI_Databases\pmi\pmiloadtmp.mdb"

:Load
"C:\Program Files\microsoft office 2003\OFFICE11\msaccess.exe" "c:\apps\CI_Databases\pmi\pmiloadtmp.mdb"/x updatedata
rem Compact databases
"C:\Program Files\microsoft office 2003\OFFICE11\msaccess.exe" "c:\apps\CI_Databases\pmi\pmiloadtmp.mdb"/compact

ren "c:\apps\CI_Databases\pmi\pmiload.mdb" "pmiloadold.mdb"
ren "c:\apps\CI_Databases\pmi\pmiloadtmp.mdb" "pmiload.mdb"
if exist "c:\apps\CI_Databases\pmi\pmiload.mdb" if exist "c:\apps\CI_Databases\pmi\pmiloadold.mdb" del "c:\apps\CI_Databases\pmi\pmiloadold.mdb"

All help is greatly appreciated as this has been bugging me for some time now.

Thanks
SamIf all your DTS package is doing is running a .cmd (batch) file, why not run it instead from a scheduled task. In the schedule task step, select task type of Operating system command and type in the path and name of the batch file.

This may not resolve the problem, however. I suspect that the problem lies within permissions. What account is the SQL Agent user set up to run under? Then think about what permissions your account has that the SQL Agent account might not have.

Regards,

hmscott|||Thanks hmscott.
That works when i change the SQL Server Agent startup account username and password.

Scheduled backup does not run

I used the backup wizard to create a recurring backup to disk, but the the w
hen I look at the location where the backup file is to be created, I see tha
t it does not run. What am I doing wrong?Is the SQL Server Agent service started?
Tibor Karaszi, SQL Server MVP
http://www.karaszi.com/sqlserver/default.asp
"Jack Wachtler" <jack_wachtler@.comcast.net> wrote in message
news:4E4DF6C6-0DD1-430A-95CE-2713AA1D4030@.microsoft.com...
> I used the backup wizard to create a recurring backup to disk, but the the
when I look at the location where the backup file is to be created, I see
that it does not run. What am I doing wrong?|||I started the agent. Thanke for helping out a newbie.

Schedule to export the data to csv file

Hi,
I'm new to SQL. Recently I need to setup a schedule job to export data into
csv file every month. I know I can do the schedule part, but I need help
with writing exporting data script.
select * from tb1 to file info.csv
Thanks in advance,
SarahCreate a data transformation services package and schedule it. See DTS in BO
L
for more info.
AMB
"SG" wrote:

> Hi,
> I'm new to SQL. Recently I need to setup a schedule job to export data int
o
> csv file every month. I know I can do the schedule part, but I need help
> with writing exporting data script.
> select * from tb1 to file info.csv
> Thanks in advance,
> Sarah
>
>|||You can do this a couple of ways. The easiest would be to create a DTS
package with the source as your SQL database & the destination as the file.
You can make it a job & schedule it to run at defined intervals. An
alternative is to use oSQL & define the destination. Again you can schedule
it to run it whenever you want. Details about DTS as well as OSQL.exe can be
found in SQL Server Books Online.
Anith|||Thanks Anith and Alejandro for your quick response. I didn't explain my
question properly. I like to gather data from a few tables and export it.
Would I be able to do this as well? I know how to export one table using
DTS, but not from several tables.
Thanks,
sarah
"Alejandro Mesa" <AlejandroMesa@.discussions.microsoft.com> wrote in message
news:4BCB9529-FD4F-4DFC-98F9-A09A8994EC6F@.microsoft.com...
> Create a data transformation services package and schedule it. See DTS in
> BOL
> for more info.
>
> AMB
> "SG" wrote:
>|||>> I know how to export one table using DTS, but not from several tables.
You can do the same with the resultset of a query which involves multiple
tables.
Anith|||Hi Anith,
I'm new to SQL. I don't quite sure how to do the same with resultset of a
query. Would some sql scirpt be involved?
Would you mind giving me more information about it?
Appreciate it.
Sarah
"Anith Sen" <anith@.bizdatasolutions.com> wrote in message
news:evi1NBcSFHA.3516@.TK2MSFTNGP10.phx.gbl...
> You can do the same with the resultset of a query which involves multiple
> tables.
> --
> Anith
>|||>> Would you mind giving me more information about it?
Sure, but did you get a chance to check SQL Server Books Online regarding
how to use DTS? If you haven't, please do.
DTS Import/Export wizard is a simple, easy-to-use interface which among
other functionalities, allows you to transform & transfer data to external
destinations in pre-defined formats like CSV, tab-delimited etc. There are
provisions in DTS wizard to write SQL queries & specify the output formats
which can be used in your case. Also, for commonly found issues, there is an
excellent website: www.sqldts.com
For reference:
http://msdn.microsoft.com/library/e...ls_wiz_8vsj.asp
http://www.sqldts.com/default.aspx?276
Anith

Schedule SQL job from .net 2005

Hey guys I have a job which runs an SSIS package. But as this package needs to run everytime a file is uploaded, I was wondering if sql jobs can help in here...

Does anyone know how can i schedule this job which executes an ssis package frm .net 2005?

Or

Can i write a custom schedule for a job which will check if certain value has changed in the table if yes run the job if no just wait

or do u guys have any suggestions or pointers...

Regards

You could use notification services to file when the upload completes, then have a job start your SSIS package when the message arives in the queue.

Schedule SQL job from .net 2005

Hey guys I have a job which runs an SSIS package. But as this package needs to run everytime a file is uploaded, I was wondering if sql jobs can help in here...

Does anyone know how can i schedule this job which executes an ssis package frm .net 2005?

Or

Can i write a custom schedule for a job which will check if certain value has changed in the table if yes run the job if no just wait

or do u guys have any suggestions or pointers...

Regards

You could use notification services to file when the upload completes, then have a job start your SSIS package when the message arives in the queue.

schedule sql file

How do I make a daily schedule to execute a sql file? Thanks.Use the SQL Server Agent.
In your Enterprise Manager, goto Management-> SQL Server Agent -> Jobs
"Allen Iverson" wrote:
> How do I make a daily schedule to execute a sql file? Thanks.
>|||Hi,
Create a .BAT file with the .SQL file using OSQL
OSQL -Uuser -Ppassword -Sserver -ic:\act.sql -oc:\act.out
Then schedule the batch using SQL Agent job with type as "Operating system
command".
Thanks
Hari
MCDBA
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:elWG4I0qEHA.3728@.TK2MSFTNGP09.phx.gbl...
> How do I make a daily schedule to execute a sql file? Thanks.
>

schedule sql file

How do I make a daily schedule to execute a sql file? Thanks.
Use the SQL Server Agent.
In your Enterprise Manager, goto Management-> SQL Server Agent -> Jobs
"Allen Iverson" wrote:
> How do I make a daily schedule to execute a sql file? Thanks.
>
|||Hi,
Create a .BAT file with the .SQL file using OSQL
OSQL -Uuser -Ppassword -Sserver -ic:\act.sql -oc:\act.out
Then schedule the batch using SQL Agent job with type as "Operating system
command".
Thanks
Hari
MCDBA
""Allen Iverson"" <no_spam@.bk.com> wrote in message
news:elWG4I0qEHA.3728@.TK2MSFTNGP09.phx.gbl...
> How do I make a daily schedule to execute a sql file? Thanks.
>

Schedule report delivery for all parameters

Is it possible to schedule the delivery of a report (to a file share
say) for each possible value of a parameter?
So, if I have a report that accepts a value for parameter @.color and
shows the corresponding tshirts in that color, and there are 3 possible
values for @.color (red, green, blue), can I somehow schedule the report
to automatically run for each value (resulting in 3 delivered reports)?
Thanks!You want to look into DataDriven Subscriptions. These allow you to execute
a query and use the results to drive subscriptions.
--
-Daniel
This posting is provided "AS IS" with no warranties, and confers no rights.
"Jim" <emailjeffp@.yahoo.com> wrote in message
news:1108132927.922517.3740@.l41g2000cwc.googlegroups.com...
> Is it possible to schedule the delivery of a report (to a file share
> say) for each possible value of a parameter?
> So, if I have a report that accepts a value for parameter @.color and
> shows the corresponding tshirts in that color, and there are 3 possible
> values for @.color (red, green, blue), can I somehow schedule the report
> to automatically run for each value (resulting in 3 delivered reports)?
> Thanks!
>